Problem with Access Database

[Melvana]

Here's my problem:

I have an application (that I didn't made by myself)
that can make backup of the databases that are used by it.

I have to make a form that allow the user to restore the
database that were backed-up. But my problem is that the
database(called 'transport.mdb') is open when I try to make
my restore and it won't let overwrite it.
Of course, I know I need to 'close' the database but I
really don't know how the fu** should I made this possible.

Please help me...

[curlywink]

Is the backup database is in compressed/zip form or whatsoever? Try to figure out how the application backs up its database?

[Gary.Lowe]

Melvana

The only way you will be able to do this in acces is by creating a front end database which has all the forms , queries etc.

The tables from the original database will be linked to this front end.

You can run the back up from the front end by dropping the links to the database backing up the re-establish the links.

You can then create a form that will drop the links to the main database, delete it copy the backed up dtabase base and rename it to the the original deleted database and then re-link the tables.

Phew!

Hope this is of use to you.

The easiest way to back up in access is to use the CompactDatabase method. The easiest way to link tables is in the TransferDatabase method,