Access DB Size

[jle0003]

I have a 2007 Access Database with 14 tables, 3 queries, 21 forms, 2 reports, 7 macros, and 3 modules.

I know that there is no row/record limit but there is an overall file size limit of 2 GB.

What I need to know is the average size of a record in my DB so I can estimate how many records it can hold. I attempted this by making a copy of the existing DB with all of it's 200+ records and then deleting all the records, leaving only the structure (tables, forms, etc...). However, when I compared the size in the properties of the "empty" DB to the functional DB, the size was exactly the same (20,744 KB). How is that possible? Is there a way I can find out the average record size so I can estimate how many I can fit in the DB with the 2 GB limitation?


Please help! Thanks!!

[RayMilhon]

Do a compact and repair on the structure only DB. In MS access even though the records are deleted and to the best of my knowledge there is no way to retrieve them they still occupy space in the Database. A compact and Repair will clear those records out.

[jle0003]

That worked. Thank a lot!