Compacting backend data

[marathonlady]

How do I compact my backend database from within my front end? When I run the code in the module it works. When I log into my front-end program and click on the button that runs the compact code I get the message that someone is using the database and can't compact it now.

Help!!

Thanks in advance.

 

[jaydwest]

You cannot compact the backend because you have links attached to in from the frontend database. If you want to compact the backend under program control, you will need to open a new database that does not have links to the backend, close the frontend, and run the compact from the new database.

We do this. Each of our applications includes a third database, the Utility Database, that performs this function as well as performing backups which cannot be done from a database in use.

Give this a shot.

 

[marathonlady]

Thanks, Jay. I was beginning to figure out that I couldn't compact in the same database.

 

[Autoeng]

You can get a utility to place in your FE to compact the BE at www.rogersaccesslibrary.com Look under Downloads for the appropriate version of Access that you are using for CompactBackEndDBxx.mdb.