Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

creating .exe program to compact Access database 1

Status
Not open for further replies.
airon

airon

Programmer
Jun 21, 2001
21
US
I would like to create a program that will automatically compact a database. If anyone could provide an example or point me in the right direction, I would appreciate it.
Thanks in advance.
 
Sort by date Sort by votes
You don't need to create a program to perform the compact. You can use the command line to do the compact. Include the following in a batch file and use the Tas Scheduler to run it. This example is for Access97.

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" C:\YourAccessDatabase.mdb /compact /CMD
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
748
grnzbra
grnzbra
ameedoo3000
  • Question
switch between two open database
Replies
12
Views
520
Andrzejek
Andrzejek
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
343
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
526
TheresAlwaysAWay
TheresAlwaysAWay
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
565
OCM
OCM

Part and Inventory Search

Sponsor

Back
Top