Printable View
hi. I have just made my first Db, but I suspect it grows too quickly. there are only 4 tables in the Db. the main table have 25 columns. a 'Byte' and 'Text' (the longest is 45 symbols) types dominate there. so, for this moment I have only 300 records, but my Db is already 10 Mb... I am sure with normalization everything is ok. so what's the problem??? Is it normal?
thanx!!!
Arnas
Hi amas,
I have seen this before. I am not sure as to the cause but I had an access database with 60 records which was 40MB. I recreated the tables in a new database and exported / imported the data. This was the only resolution I found.
Lenin
The thing about Access databases is that when you add a record, the file grows in size. But when you delete a record, the file does not shrink in size. I have heard various explanations as to why this is the case. The article at the following link shows how to compress the database with code:
http://www.vb-world.net/databases/tip482.html