Backup Open Source Software

Is there a way to schedule an automatic backup of an access database without having to do it manually?

I have a database that I want to be able to automatically backup. Is there a way to do this internal to Access or do I need to buy software to do this?

Public Comments

1. Unfortunately, there is no simple built-in function to do that because Access is not a true Client/server DB, but you can do it in at least 3 ways: - through a third-party software ( http://www.topshareware.com/Access-Autopilot-download-11909.htm ) - by setting up a .bat file to copy your .mdb file when no one is accessing it (not too reliable) - with some pretty complex VBA code (see Source, haven't tested the code myself) Another solution might be to move to SQL Server 2005 Express Edition or any other proper Client/Server DB.