database size issue of 2GB

[neilb]

Hi

I have been writing a database for a week and imported approx 200,000 rows of data and have have 4 make table querys and 150 other queries. It has reached a size of 1.99GB and I am getting "invalid Arguement" messages when I try to run the make table queries.

A lot of my queries are doing the same process but only pulling off the same data in different groups of weekly sales. Is there a way to make one query or action do this in one go so that it takes up less space in MB's? I have to have the weekly sales sheets in separate sheets to export into excel.

Any help would be great

many thanks

 

[dk]

Might be an obvious question, but have you compacted the database recently? Click Tools, Database Utilities, Compact and Repair Database. To improve performance MS Access doesn't release hard disk space when it is no longer needed and this can quickly lead to excessive bloat.

 

[neilb]

That worked great - many thanks

 

[Joe4]

If you like, you can make Access compact the database automatically every time it closes it. Go to Tools | Options | General and click on the "Compact on Close" option.

It takes a few seconds longer to shut down, but it keeps the size down.

 

[neilb]

Thanks I have done that.