Copying databases

[Guest]

Hello,
I am trying to create a button to update the current front end. i want it to
replace the running database with the updated one stored on the server. I
have tried a few things such as File Copy but obviously the database is
locked as it is currently open.

Is there a way to close a database but still have some code running to copy
the file?

many thanks

James

 

[Marshall Barton]

I am trying to create a button to update the current front end. i want it to
replace the running database with the updated one stored on the server. I
have tried a few things such as File Copy but obviously the database is
locked as it is currently open.

Is there a way to close a database but still have some code running to copy
the file?

Take a look at: http://www.granite.ab.ca/access/autofe.htm
for an example of how to update a dront end.