Compacting Access Database From a Form with DAO's

[wusinik]

I am trying to compact my local databse every time data is written there(initiated by pressing a command button)...the problem is that I get a message saying that the database is already opened for exclusive use by myself. There are DAO's on the form. Can I execute the compact command even if the form has DAO's?

Thanks

 

[sunaj]

Hi,

You've probably have the database open.
You can't compact the database when it is open. Close it and then compact it.
Then the datebase is closed you can compact it by setting a reference to 'Microsoft Jet and Replication Objects' and

JRO.CompactDatabase StrCon, NewStrCon

Where StrCon conbtains your connection string and NewStrCon is your connection string with a new database name. If you like you can use 'kill' to delete the old database and 'name as' to rename the new to the original file name.


Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'