Compact database from VBA

R

Reehka

I have DB1 and DB2. I would then like to compact DB2 from
the VBA-code in DB1.

How is that done?
 
D

Douglas J. Steele

Use the CompactDatabase method of the DBEngine object (requires that a
reference be added to DAO 3.6 if you're using Access 2000 or 2002)
 
R

Reehka

Thanks.

Could you please explain the parameters - my help does not
work properly (and reinstalling is not helping...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Tables from Password Protected DB 2
Appending Records from Table to Table 1
Copy a table in an external database 1
Sharing VB Classes with Other Databases 2
Maximize other application from VBA 14
Link problems 2
TimeStamp Record 7
closing another database 1

Top