Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copy .mdb file
- Thread starter daytona
- Start date
It will not be safe to copy as the tables and other objects may be in an inconsistent state. For instance a user might be increasing everyone's pay by 10% with an update query and you copy when half the people are done. To say the least if you succeeded in a copy and restored half the people would be very unhappy.
Most copy software will ignore or refuse open files for this reason.
Industrial strength databases such as SQL server use the database engine to do the backing up as that knows about open transactions and can guarantee consistency. The Operating system can never do that.
Ken
Most copy software will ignore or refuse open files for this reason.
Industrial strength databases such as SQL server use the database engine to do the backing up as that knows about open transactions and can guarantee consistency. The Operating system can never do that.
Ken
Me i suggest you to put all new information (Key Field) in temps file with the date & time created and modified. Each day you can backup all record only modified and new record of the previous day in other table (This limit the trafic on server depending the number of record you have in one day). Finaly you can make a backup in real time, i.e. record your all informations in 2 databases.
All this can be done with VBA Dao.Database, Dao.Recordset, etc.
Eric Poirier
All this can be done with VBA Dao.Database, Dao.Recordset, etc.
Eric Poirier
- Thread starter
- #4
- Status