How to copy a database?

[miroku800]

A little history
I designed a program in VB6 which used an access database with the aid of a then workmate (who has now moved on and lost interest) which was in two parts. A master program and a remote viewer.

Now the problem
the master program is working fine and has provision to make a copy of the database to a second location and updates its master database and copy no problems
the remote viewer also works in that it asks where the database is on first run and copies it into its own store, what i then need it to do is update the database in its store from the copy when a key is pressed (the key is already there and is the exit from the results display back to the main screen to make another selection)
it needs to ignore the error generated if by chance the copy database is in use (being updated by the main program) when it tries to update and just wait until next time the 'exit' key is pressed and try to update again ( I am assuming the remote program would wait until its copy was done before allowing further interaction).
while I can manage the design side of the interfaces and understand how and where the information is stored in the database I cannot get my head around how to duplicate the copy database and paste it into the store overwriting the existing old copy.
the program does update its stored database on restart without asking its location but i cant workout where this is being done .

will someone please take pity on me and point me in the right direction for the code

Thanks in advance
Rob

[SkinHead]

It's hard to say what the problem is without seeing the code.

It's a bit drastic, but you could zip the VB projects up & post them, or if they're too big, then email them to me at
<E-mail address removed by Moderator>

[Killer42]

Sorry SkinHead, but if you want people to e-mail you, they can do it by clicking on your profile and selecting the "send a message via e-mail" link. But you need to turn on the option in your "control panel" first. (TheScripts control panel, not Windows.)

The site guidelines say not to post your own or anyone else's e-mail address, as spammers and scammers harvest them from forums like this.