Compact And Repair Linked Database
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?
Re: Compact And Repair Linked Database
As a test, open your mde and your linked mdb. Then from the mdb do a manual C&R and if it works then its possible. Just make sure your mde doesnt have any of the tables open in any type of display view before programmatcially C&R the mdb from the mde.