can not compact and repair database

[arpitraval]

Hi,

I have one .accde access database. It has already crossed the limit of 2 GB size and now I am trying to compact the size by doing the compact and repair but its not workin. After compacting it remains the same 2 GB size. What to do now!!!!!!!

 

[CraigDolphin]

One thing you could try is to import all the tables/queries etc into a new database project and compact/repair that.

However, I have to ask how you managed to get such a large file size in an access database? If you have a properly normalized design, and are not storing imges etc, that represents a godawful amount of data.

If you want some friendly advice, if you have that much data in a properly normalized deign then you probably should look into using a SQL server or MySQL backend with Access used solely for the front end if you must use Access.

And if your database design is not properly normalized, then you need to read up on the subject and rebuild using those principles.