Advertisement

07.10.2008 at 12:03PM PDT, ID: 23555025
[x]
Attachment Details

Compact and Repair Database (db1.mdb?)

Asked by bejhan in Microsoft Access Database

Tags: MS Access, 2003

When compacting and repairing a database, Access doesn't actually compact the current copy of the database, it just saves it as db1.mdb? Am I correct?

If so:

I am building an application which there will not be an admin present to compact and repair. I am using a function to this automatically at program start. How would I go about replacing the current copy of the application with the compacted one?Start Free Trial
1:
2:
3:
4:
'This function runs Access's compact and repair feature
Public Function CompactDatabase()
   CommandBars("Menu Bar").Controls("Tools").Controls("Database Utilities").Controls("Compact and Repair Database...").accDoDefaultAction
End Function
[+][-]07.10.2008 at 01:02PM PDT, ID: 21976865

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.10.2008 at 01:48PM PDT, ID: 21977259

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: MS Access, 2003
Sign Up Now!
Solution Provided By: bejhan
Participating Experts: 0
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628