By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,510 Members | 1,141 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,510 IT Pros & Developers. It's quick & easy.

How to copy a database?

P: 21
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
Jul 12 '07 #1
Share this Question
Share on Google+
2 Replies

P: 39
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>
Jul 12 '07 #2

Expert 5K+
P: 8,434
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.
Jul 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.