Backup access file on startup

[Eikenhorst]

Hello,

I have made an Access database that works perfectly. But the manager wants to have more security that it will never fail with huge loss of data. So he wants the program to create a backup on the personal hard disc so if something goes wrong the last user has a good backup of the complete database.

I’m not really pleased with this idea, but if he wants to have it this way than it should go this way. But now my question: Is it possible to backup the Access file you’re opening from the network to a copy on your personal hard disc?

Could you please give me an example of how I should do this? The original location is: T:\Engineering\Database.mdb and this file should be copied to P:\DatabaseCopy.mdb

Any help or ideas are greatly appreciated!

 

[gemma-the-husky]

do this off line - just copy the database to a different loaction. assuming you have split fe/be. you are only worried about the be, as you will/ought ot have code backups anyway, and the code is not volatile

dont you back up your network disks anyway