My Database Reports the wrong size

  • Thread starter Thread starter lrd
  • Start date Start date
L

lrd

Guest
A database I am developing reports it is nearly 2Gb in size. As a result I cannot compact and repair it. How do I fix?
 
I'm not sure whether you mean that Access won't let you compact and repair or just that you don't have sufficient disk space to do so.

One solution, assuming you've got some free disk space, would be to create a new mdb and import the contents of the original database into it. You'd need to set certain things manually (e.g. Startup options) but it would cover most things.

Simon
 

Users who are viewing this thread

Back
Top Bottom