Copy over current Database

  • Thread starter Thread starter Katrina
  • Start date Start date
K

Katrina

We have a database that will probably end up on people's
hard drives. The database will not need to be updated
that often, maybe once every three months.

I was asked to make a button in the database that would
allow the user to easily update his/her hard drive copy
(UserDB).

Basically, they would like to push a button to copy one
folder containing the database and the information within
(the master copy) to the current storage location.

I can figure out all the logistics except how to close
UserDB so that I can copy over it. I set up another
database (Updater.mdb) to run the code of copying over the
folder, and I can open it from UserDB, but how do I close
UserDB before running the code in Updater.mdb. Right now
Updater is set up to run the copying code automatically...

Thanks for your help
 
Katrina,
To achieve this you need to have another Access Db (or VB executible) on the
server eg DBUpdate.mdb

When the user clicks the Update button it uses the Shell cmd to launch
DBUpdade, passing to it as a command line argument a string that contains
the path and file name of the Users DB (to be updated). The button then
closes the User's DB.

DBUpdate tries to rename the User's DB and if it fails, it waits and tries
again (however many times, say 3 times with 5 second delays), once it
renames the user's DB, it copies the updated DB to the User.

You could also use replication to achieve this and you could also deploy
copies of DBUpdate to each User PC aleviating the need to find the UNC to
pass to it.

Doug
 
This is exactly what I want to do. However, the shell
function is not letting me call out a .mdb file. Can you
please give me an example of how I would call out a .mdb
file with the shell command?

Also, please explain to me how I would "pass to it as a
command line argument a string that contains the path and
file name of the Users DB "

I'm pretty sure that i will distribute individual copies
of the Updater.mdb, but in case I don't I would like to
know how to do the above.

Thanks for your help,
Katrina
 
Back
Top