Reducing Database Size

[Guest]

I frequently have to import data into different Access databases for analysis
and these databases are normally quite large (around a GB). After analyzing
them, I normally need to record the results in a table. (This can happen
several times). And although I remove the initial tables to try to reduce the
size of the database (to stay under the 2GB limit), the database continues to
remain the same size.

Is there anyway to permanently remove this data so that I don't exceed the
limit with any databases? I know that I could split the databases, but I have
to do this on many databases and this would double, triple, or quadruple the
workload for a single project.

Thanks in advance if anyone can help!

Rich.

 

[Guest]

When you remove tables or data from the mdb, it doesn't reduce the size of
the MDB, for that you need to compact the MDB.

Look at this link
http://office.microsoft.com/en-us/assistance/HP051874491033.aspx

 

[aaron.kempf]

mdb is crap and for babies

use ACCESS DATA PROJECTS with MSDE or SQL Server.