Hi,

I have an ms access project that is divided into 2 parts:
1. back end- only the database tables.
2. front end- all the forms/reports/ query. the database is connected as link tables to the back end file.

I'd like to replace the current back end file with an upadted back end file from a button in the front end.

basically what I need to do is:
1. disconnect the (current) back end tables - any ideas how?
2. replace the back end file (simple copy command)
3. reconnect to the (new) back end tables - any ideas how?

or maybe you have suggestions to do this in another way?

thanks,