Copying databases

J

James

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
 
M

Marshall Barton

James said:
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?
Click to expand...


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