I am haveing issues with the Compact/Repair Function for a Dbase that I have created. Background:
I have a Dbase that I built that exists on a network drive by muttiple users. (I am a novice Acess User) Every once in a while the file size gets really big (365 MB from and original 57 MB) I have been running the Compact/Repair function for a while with no errors.
Now I try to run it and the screen goes black as always during the process but when the the progress bar only show 3 "dots" the main menu form returns and I am able to use the system. It is not compacted (the file size has not changed.)
I have made sure that there are no users in the dbase upon running this.
What could cause this error and how do I fix this? The file is now around 500 MB. (10 times it's usual size)
That's happened to me once and it was because there was no room on the drive to compact the database.
Copy the database to another location - compact it - then turn on the compact on close option from the Tools - Options - General tab. This way you don't have to worry about it.
But One thing I have done
Yes turn on the compact on close (Back end database)
Create a Autoexec macro to close Quit the Program
Then I have a Scheduled Task That Run @ 2.00am every day that open te database the macro Close it the compact on close kick in job done. LOL
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.