Compacting database in Access 2003

[Maarten]

Hi,

The size of one of my Access 2003 files is larger that 2 gigabytes. When I
want to run queries I get I the error message "invalid argument". Microsoft
help pages tell me I should compact the database, which I do but while
compacting I get the same error message. I also even deleted some large
tables in the database to make sure it will not exceed the 2 gigabyte limit
anymore. So what should I do? Compacting doesn't work but like this my
database is unworkable.

A second question: is there a way of finding out the size of individual
tables in your Access database? I cannot find anything on that in the Access
help files.

Thanks!

regards,
Maarten

 

[Maarten]

"Maarten" schreef:

The message I just posted was about an Access 2000 database instead of an
Access 2003 database. Sorry for the inconvenience. But the question stays the
same.

 

[Allen Browne]

If you can't compact, you may be able to create a new database and import
everything:

1. Create a new (blank) database.

2. Disable Name AutoCorrect by unchecking the boxes under:
Tools | Options | General | Name AutoCorrect

3. Import the objects from your large database:
File | Get External | Import

No: there is no real way of calcuating the size of the data individual
tables. If you have any OLE Objects in your tables, they would be the first
suspects though.

 

[Jeff Boyce]

Maarten

A very "rough" way I've used to estimate object size is to create a new
empty Access .mdb file and import a single object. The difference between
the size of the empty .mdb file and the version with the imported object is
an approximation of object size.

An even rougher approximation for size is to look at the documentation on
the table for fields/field sizes.