Size Difference, Normal?
Nov 3, 2006
Hello all!
Maybe strange, but I have litterely created a new database from my "old" one. I did this because I thought the size of the database was growing way to fast.
What I did was open two instances of Access, one with a new empty database open and one with the other "old" database open.
I manually created all tables, queries, forms and code again by selecting everyting in design view, copying it, creating a new table/form/query/module in the empty database and pasting the data. After that I had to set some properties and it was ready to go.
After compiling and compacting the new database was just 718kb in size. Empty that is. Then I added a couple of cases, compacted again, added some more, compacted again. (copies of the same data on different records). The same I did with the other "old" database.
Both now have 12 clients with 2 cases (totalling 24 cases) every client and every case existing of the same data.
The new database is now 1.120KB in size, the old one is 2.096KB. That's almost double. The only real difference between the two that I can think of is that one has a 20KB image tiled on the background of each form (the same image though) plus, of course, in the one database I've been designing, adding, deleting more.
But how is it possible that these data sizes are so different? 100KB difference, ok. But almost double the size? How is that possbile and why? Are there things I can do to keep it at bay apart from using the Compacting and Reparing option? Plus: Is this normal?
Edit: I emptied them. One is now 812KB in size empty, the other one is 1496 empty. Still... double the size. ?
View Replies
ADVERTISEMENT
Aug 19, 2014
I am using Access 2007 database in work environment. When one of my colleagues tried to update some records in a table, it created a backup of the database.
The issue is that the size of the actual database is much smaller than the size of the backup. However all the data are present and I don't think any data has been deleted.
But I don't know why there is a difference in size?
Some of the tables in the database are linked from MS SQL Server.
View 4 Replies
View Related
Aug 29, 2005
Will keeping your field size shorter result in a smaller MDB file?
Or does Access only use as much space as there is real data in its fields.
Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.
Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...?
Thanks............
..dc
View 3 Replies
View Related
May 17, 2006
I created a DB that I put security on and now everytime I create a new DB or go into a any DB I have to use a password even though it shouldn't require one. I know it has to do with the SYSTEM.mdw file but all of them say the same thing and I can't seem to find the problem. Please help.
View 3 Replies
View Related
Jan 26, 2008
Hi, I'd like to know your opinion about the following problem :
http://img262.imageshack.us/img262/4256/toysmm0.th.jpg (http://img262.imageshack.us/my.php?image=toysmm0.jpg)
I'm given this table and I'm supposed to say in which Normal Form it is. I'm not sure but I guess in this specific case I need to consider both Toy_ID and Order_ID as primary key. Then one can see that Order_Date ist dependent on Order_ID but not on Toy_ID, then the table should be in 2NF, right ?
The table is not in 3NF because even though Producer is dependent on Toy_ID (at least I think it's dependent), City and Country are not directly but only transitively dependent on Toy_ID. Am I right ?
Thanks !
View 2 Replies
View Related
Nov 28, 2005
I currently have a database thats A Replica which I need to Convert Back to a Normal Data file, Is there a simple way of doing this other than creating a new db with tables then using Querys to add the data from the replica.
I'm using 2002 and the replica if sized around 470Mb with over 200 Tables.
also does anybody know if the file size for assess 2002 was incresed from access 2000's 2Gb.
thanks
mick
View 2 Replies
View Related
Dec 1, 2005
Hey folks!
A favor to ask: Pat Hartman posted an example db shortly before this site was attacked that dealt with setting up a form in a non-normal fashion to enter/display data that was in normalized tables. Did anyone download and keep a copy?
I downloaded it and was going to study it to try to build something similar for a lab application, but I lost my copy and can't get it back. A search here did not pull the post up, so I'm assuming the attack got the post, which was in the example DB section.
If anyone still has a copy, or if you see this Pat, would you mind posting the file again? I'd really like to study this one.
Thank you in advance.
View 1 Replies
View Related
Apr 4, 2007
Hi, i'm new here and I know there's a lot going on but i was hoping someone could point me in the right direction or give me a few tips...
I've imported a very large (nearly 15000 records) set of data into an Access database as one big huge table storing various bits of information about coins. As far as I can tell, the data is in at least first normal form, in that no multiple values are stored in any columns (not yet sure of the technical term - field?)
Anyway, I've managed to use a make table query to separate out some of the content of the table into separate tables with relating entities.
One question is, and please bear with me - How do I add an autonumbered primary key to these newly separated out tables and then add these autonumbered items to the original tables as IDs so that I can set up relationships? Is there a "proper" way to go about describing this?
The following consists of ALL the fields in the original table and how i've split them up by table:
STOCK
Group
ItemNo
ListNo
TypeCode
ActualDate
SortDate
CostPrice
SalePrice
Estimate
StockLevel
DateEntered
DateSold
Archived
Ref1
Ref2
Picture
Description
Cats
DenomCode
TypeCode
PeriodCode
ArchiveWhenSold
NotForSale
KeepSold
StockItem
Highlight
OnLists
OnWeb
Proof
DENOMINATIONS
DenomName
DenomCode
DenomHeading
DenomValue
PERIODS
PeriodName
PeriodCode
PeriodHeading
PeriodStartYear
PeriodEndYear
VARIETIES
Variety
The Variety field in the Variety table is especially problematic. There were 1259 varieties stored in the original table which are now in a separate Varieties table which is great. But how do i now add an autoincrement number and call it, say, VarietyID, but then link each Variety back to the main list of coins but replace the full Variety description with the newly created VarietyID?
If any of that made sense, i'd REALLY appreciate some wisdom here.
Thanks
View 14 Replies
View Related
Mar 19, 2006
Im sorry about the stupid questions!
How can I open a report in a view which will let me test my buttons? I only seem to be able to open it in print preview!
View 4 Replies
View Related
Feb 8, 2006
Hello All!
As in the topic stands that im looking for a code that hides Access and it starts up like a normal program. Ive searched several things on the forums and i actually did found something only he didnt gave the code ;(.
So first question:
How can i do this with a code?
Second question:
What do i need to change on my forms?
Etc etc :)
Thanks alot in advance!
View 6 Replies
View Related
Aug 1, 2005
I'm wanting to get a very, very pale shade of gray as the background colour for an Access form, as well as for several text boxes on it. This is so that users can distinguish editable regions (white bgs) from uneditable ones (light gray bgs).
The default colours that pop up in the menu choices are too dark for this. I've tried using a tiled image for the background of the form, which works fine. But I'd like my uneditable textboxes to be selectable (so users can copy data) whilst being that colour too, which can't be done.
Therefore I'm looking for either the number code for a very very light gray colour (Access' default lightest is "12632256") or some sort of translator tool to let me know how on earth these numbers relate to anything in computing -- I mean, what do those numbers represent? Are they html=no, hex codes=no, rgb values, no... I mean, how is Access coming up with those numbers? I've tried just getting a light gray using trial and error and can't figure it out (even ended up with lime green at one point - very nice on the eyes lol).
Anyone shed some light on this? :rolleyes: :D
View 3 Replies
View Related
Jan 11, 2006
Simple question
Why do I have 2 Office Record locking, with different names. One is called Secured (which is ok), but the second one is called the same name of the Database. My database is running real slow. I have compacted and repair, but still running slow. I thought it might be the network, but when I open my old backups they run normal.
Any ideas?
View 4 Replies
View Related
Oct 11, 2007
Hi..
I got a access file from a friend of mine, but when i open it in access, i don't see any tables or the standard menu buttons.
The only menu i see, is a docked menu with a couple of submenus, wich in turn open forms, where you can enter data..
How can i see the tables and bva script behind this access file?
I tried F11 and Alt-F11, but is does nothing.
He won't tell me how he did it, because he doesnt like to share what he knows...
Can anyone help me??
Thanx !
View 6 Replies
View Related
Apr 22, 2013
I saved my database as ACCDE file which is executable now the problem i am facing is i can't edit my database since i can not view it into design view.
How can i change it to its normal file format
View 4 Replies
View Related
Mar 4, 2014
I have built a database using Access 2010 using the 'web' format for the forms, reports and tables.
This has been fine so far as I have been using macros for my clickonevents.
However I now need some functionality not available in the web forms macro expression builder. Namely Openquery, (it is not on the available list). I therefore want to copy my forms formatting and properties to a normal non-web form allowing me to enter vba code.
Is there no way of doing this though - will I have to redesign the form again from scratch?
View 2 Replies
View Related
Jul 20, 2005
I am wondering why the alteration to my form in design view is not reflected in the "normal" form view. I have included the two views. In design view I moved "Staff In"/"Staff ID" to the top of the form believing that as I work left to right thay would appear on the left hand side in normal view.
However, in the image of "normal" view you can see that "Staff In" is way over on the right hand side of the form.
Any ideas how I can fix this?
Thank you
http://www.btinternet.com/~peter_paterson/Access/SubFormDesign.jpg
http://www.btinternet.com/~peter_paterson/Access/SubformFormView.jpg
View 7 Replies
View Related
May 30, 2005
Hello everybody,
I’m new here and I have a question for you..
Is it possible to place round buttons or oval buttons on your forms instead of the normal square ones?
Greets,
Tom
View 2 Replies
View Related
Apr 28, 2007
Could someone clarify the difference between DAO and ADO?
We migrated to Office 2003 last year - some large organizations move at the speed of continental drift. The database is written in Access 2002 (finally have most of it up and running - with thanks), but I need to really understand the difference for the documentation - to see if there are any issues that might undermine the database during the upgrade.
View 6 Replies
View Related
Feb 24, 2008
Hey
How can I calculate the difference between two rows like:
value____diff
4________4
7________3
12_______5
/Thanks
View 1 Replies
View Related
Jun 2, 2005
Hi, I have two tables, one being a subset of the other. What I want to do is write a query that lists data in the larger table that is not in the smaller one. In effect I want to subtract the data in the smaller table from the larger table and list the remainder.
I have tried something like:
Select a.oem from a,b where a.oem not in (select b.man from b);
This query does not complete and I get 100% CPU usage :( . The largest of the tables has roughly 4000 records in it. Any ideas? Am I doing something wrong?
Thanks
View 3 Replies
View Related
Jan 18, 2006
I have a Transactoin Table that holds the following fields:
TransID (*Primary Key Numerical Value)
OrderID (Non Unique Number Value, One Order can have multiple Transactions attributed to it.
Status (Numerical Value ranging from 0 to 32, each is a different phase in the life of a transaction such as 0 means Transation Created, 1 through 31 are various actions with 32 beign the transaction closing)
Date (The date in which a particular phase of a particular transaction happened.)
Reason (The Description of a phase. This is the only text field whose contents are relative to the Status field in the same table.)
I need to find the amount of time passed from the first Transaction to the last transaction of each individual order, which will be displayed in a report. Unfortunately not every order goes through all 32 phases, in fact most dont. The individual orders have a random amount of phases that they go through but each have a starting one (which ranges from 0 onwards) and an ending one (once again it is not necessarily 32). The dates correspond to the numbers in an individual order which means that if an order has the following phases:
1
2
4
6
Then the dates of each phase will be one after the other like the Status Number as shown above. Anybody knows how to do this? I need to find how much time passed from the first transaction to the last for each individual order qand display it in a report.
View 7 Replies
View Related
Jan 30, 2006
This has probably been raised before but here goes anyway.
I have two fields in a table: time_in and time_out, both as date/time fields and formatted for short time with a mask in the form.
I need to calculate the time spent, i.e. time_in 10.00, time_out 12.15 therefore 2hours 15minutes.
any help much appreciated.
Jim
View 1 Replies
View Related
Aug 17, 2007
How can we calculate a difference of column
Example
when I have a table containing a single row i.e.
Numbers
66
45
23
52
523
563
452
133
Now I required a query that must show a difference like this
Numbers ------------------ Difference
66 ------------------------ 0
45 ------------------------ -21----------- (45-66)
23 ------------------------ -22 ------------(23-45)
52 ------------------------ +29 ------------ (52-23)
523 ------------------------ +471----------- (523-52)
563 ------------------------ +40 ------------ (563-523)
452 ------------------------ -111 ----------- (452-563)
133 ------------------------ -319 ------------(133-452)
So it is possible or not
Please tell me
Waiting for reply
Thanks
Ashish
View 2 Replies
View Related
Mar 25, 2008
hey guys im not even sure if i have the heading right for this one.
I have a table example data attached,
what i would like to do is return all transfers from that table where all the item numbers in a batch dont equal each other i.e if you subtract them all in a batch it doesnt = 0
i have know idea how to do this and dont know if this is even the right way of doing what i need which is to show transfers where some1 has transferred a product to a different one which we do want to have happen we just need to know when it was done.
any suggestions?
View 2 Replies
View Related
Oct 12, 2005
I have an existing table with a field labelled Job Number (17 Job Numbers). Each month I import a new table and match each record via another field (serial number). For each new record, one or many, I want to attach a sequential Job Number. In this example the new job numbers need to start at 18 then 19 etc. How is this possible? I am fairly new to Access so please be gentle!. Cheers
View 2 Replies
View Related
Mar 8, 2006
Hello:
I have a report with three text boxes:
Box 1 contains an employee's total weekly hours in hours and minutes: 40:00
Box 2 contains the actual total hours worked for the week: 35:30
Box 3 is the difference between Box 1 minus Box 2
I tried all the date/time functions to calculate the difference between Box 1 and Box 2 and none of them worked. I keep on getting an error message. Does anybody know how to calculate the difference between two sets of time (in hours and minutes)?
Thank you in advance.
View 2 Replies
View Related
