10-24-2004, 11:48 AM
I want to take backup of my MDB file after every saving of a record. Previously I decided to open two connections for two MDB files and save reords simultaneously in them. But this will unnecessary consume more system resources. If I attempt to execute FileCopy command from VB when the MDB file is in use then File Sharing Error arises. Please suggest any optimised way to backup my database after every record is saved.