Opening an Access_be

[garryhinch]

I have a backend database on a network which badly needs to be compacted.I need to be able to open the backend from one of the front ends of the split database and then close it again to force it to 'compact on close'.Is this possible?
Many thanks for any help offered

 

[danvlas]

Check this link:

http://www.geocities.com/danvlas/AutoCompact.html

Good luck

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[sdk]

Hi,

Your could also look at

http://www.mvps.org/access/modules/mdl0020.htm

at The Access Web.

Cheers

Steve

 

[oharab]

Or have a look at my FAQ:faq705-1955 which could be easily modified to do what you want.

B ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------