M Moore71 DEVELOPER Local time Today, 07:19 Joined Jul 14, 2012 Messages 158 Feb 5, 2014 #1 Hi, Does any one knows the code to automatically backup backend to any folder or media in Access 2010? I need codes to be backing up my Back-End automatically. I am using Access 2010 format. Thanks in Advance Moore71
Hi, Does any one knows the code to automatically backup backend to any folder or media in Access 2010? I need codes to be backing up my Back-End automatically. I am using Access 2010 format. Thanks in Advance Moore71
N namliam The Mailman - AWF VIP Local time Today, 08:19 Joined Aug 11, 2003 Messages 11,695 Feb 5, 2014 #2 If you want to "simply" copy your backend, make sure you have nothing open to it and simply copy it to a new name.... Something along the lines of: Code: Dim fso As New scripting.FileSystemObject ... fso.CopyFile myCurrDir & "AnyFolder\YourBackend.mdb", myCurrDir & "Tables\AnyFolder_" & Format(Date(), "yyyymmdd") & ".mdb" MyCurrDir in this instance contains the current folder where the database resides but can contain any old folder you prefer.
If you want to "simply" copy your backend, make sure you have nothing open to it and simply copy it to a new name.... Something along the lines of: Code: Dim fso As New scripting.FileSystemObject ... fso.CopyFile myCurrDir & "AnyFolder\YourBackend.mdb", myCurrDir & "Tables\AnyFolder_" & Format(Date(), "yyyymmdd") & ".mdb" MyCurrDir in this instance contains the current folder where the database resides but can contain any old folder you prefer.
