Compacting in MS Access 97

[Deano1976]

I have a series of three databases which filter out a large amount of data for exception reporting purposes. The databases can be accessed remotely by any of four users. Once the first database is kicked off the other two databases run in series until the reports are produced in an excel format at the end. My problem is that once all three have run - including the deletion of any data created ready for the next run of reports - I need to compact them all. Currently I have to do this manually for each database, but would like it to happen automatically once all the databases have been run and data deleted. I know MS Access 2000 can do this, but 97 doesn't seem to have the same functionality. I have tried converting the databases to 2000, but not all of the queries subsequently work and I get error messages.

Is there another way around this?

 

[spence27]

This might be one option

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

with a bit of code tinkering

 

[Deano1976]

Excellent - thanks for that. I have been trying to sort this problem on and off for the past year!