Compacting backend database in the frontend. 1

[djmc]

I splitted my access application into frontend and backend. I would like to know how I can compact my backend database from my frontend via a button click.

 

[markgrizzle]

Not sure you can since I believe you can't access the file while compacting. Take a look at FMS Inc.'s Total Access Backup, I believe it includes a scheduled compact option.

 

[JPMontreal]

Hi,

Create a DOS batch file with the network path of your back end database and add the switch /compact like:

w:\file\MyDB.mdb /compact

With a RunApp macro executes your batch file.

jp@solutionsvba.com


Jean-Paul
Montreal
mtljp2@sympatico.ca

 

[djmc]

Isn't there some way of doing it in VBA where I open the db, compact, and close the db connection?

 

[faeryfyrre]

I believe you can do this with the DAO CompactDatabase method.
You will need to ensure that NO records in the BE are open. ie no tables, queries, forms, or reports in the (any) Front-End are open.

 

[DomFino]

This can be done.
Check out the following link to Roger's Access Library.

http://www.rogersaccesslibrary.com/TableOfContents2k.asp

Scroll down the page to the C's to this download.

CompactBackEndDB2k.mdb (45 KB) ( expert ) Access 2000 DAO
Illustrates how to compact a Back-End database from the Front-End.

Dom