Compact/Repair

From: SheldonMopes@xxxxxxxxxx
Date: Sun, 30 Oct 2005 06:47:51 GMT

Here is my situation:I have several Access database projects that all
keep their back-end data in a directory on a server. I would like to
have a small Access application that could open each .mdb file, then
compact and repair it, with no user intervention other than launching
the application. Thank you for any help.

.

Follow-Ups:
- Re: Compact/Repair
  - From: Chris2
- Re: Compact/Repair
  - From: Rick Brandt

Prev by Date: Strange report error message - control must have focus
Next by Date: Re: Remotely set a db password?
Previous by thread: Strange report error message - control must have focus
Next by thread: Re: Compact/Repair
Index(es):
- Date
- Thread

Relevant Pages

Re: Compact/Repair
... > Here is my situation:I have several Access database projects that all ... > keep their back-end data in a directory on a server. ... When compacting in code you can't compact a file onto itself so you also have to ... "PathToFirstDatabaseDestination" ...
(comp.databases.ms-access)
Re: Compact/Repair
... > keep their back-end data in a directory on a server. ... There is the Jet Compact Utility, ... This can be run from .bat, vbScript, and Windows Shell Script files. ...
(comp.databases.ms-access)