Database backup

10-24-2004, 12:48 PM
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.

10-24-2004, 01:18 PM
You don't really need 2 connections to exchange data between 2 mdb files:

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum