Compact & Repair

[Brig Siton]

Can I do a Compact & Repair through VB?

If so how?

Thank you.

Brig

 

[Dirk Goldgar]

Can I do a Compact & Repair through VB?

If so how?

See this link:

http://www.mvps.org/access/general/gen0041.htm

 

[Dirk Goldgar]

See this link:

http://www.mvps.org/access/general/gen0041.htm

Hmm, I don't know whether that works in Access 2007 or later. Please post
back if you find that it doesn't.

 

[Maurice]

found this so give it a shot to play around with

First make a backup of the db before playing around.

application.CompactRepair (sourcefile as String, destinationfile as String)

'-for explanation see vba help

 

[Eighte]

Good day. It`s my wedding O`Love from WPKoraKoreaWP.
Perhaps it`s very much too much asked and say of order and sale.
End of the day, Papa Santa earns nothing.