R Reehka Jan 5, 2005 #1 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 Jan 5, 2005 #2 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)
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 Jan 5, 2005 #3 Thanks. Could you please explain the parameters - my help does not work properly (and reinstalling is not helping...)
Thanks. Could you please explain the parameters - my help does not work properly (and reinstalling is not helping...)
D Douglas J. Steele Jan 5, 2005 #4 Check http://msdn.microsoft.com/library/en-us/office97/html/output/f1/d2/s5a277.asp While that's for Access 97, it hasn't changed in newer versions.
Check http://msdn.microsoft.com/library/en-us/office97/html/output/f1/d2/s5a277.asp While that's for Access 97, it hasn't changed in newer versions.
