I have an Access 2000 application(MDE) that has a database an its tables are linked from an (MDB) file that holds all the tables.

Is it possible to determine the path of the linked database and compact and repair the linked database (MDB) from within the MDE.

To me this seems almost impossible because I would be trying to compact and repair a database that I have open.

But there might be a way...Any ideas?