Library Database using vb and access help

[samvb]

Hello guyz,
i nearly finished a library db for a school project, but my instructor said i need to include a built-in backup feature. I am stack there and need your help. How can i backup a db file when books may have been borrowed? The prob is that if user needs to restore the backed up file, invalid data may be present due to changes. How can I get around this problem? Any idea is highly appreciated.

10X

SAM

[shrimant]

If the DB is Oracle or SQL server You can just Backup the Transaction logs and from the Transaction log itself you could restore each and every piece of activity. There are professional tools available to restore from Transaction log one example is Lumigent Log Explorer.

Since your DB is Access you can use install the Free SQLServerExpres s version and then from within Access Upsize Access tables to SQL Server. Download it from the link below:

http://go.microsoft.com/fwlink/?linkid=64064

You would need the SQL Management Studio to manage your SQL Server Download it from here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en