 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007How to Backup MS Access Database?
Hi Friends, My Application is connected to MS Access database. I want to provide one option as Backup and another option for Restore. I use Delphi 5 with ADO to connect DB. What is the best way to Backup the Dabase and Restore it? I think as this is a Filebased DB, We should Make a Copy of the Database file (.mdb) and Compact the new copied file. Please suggest any idea. If i can get some Code fragment it will be helpful for me. Thanks Prabhat http://prabhatnath.blogspot.com Copying the file is the best way to back it up. Make sure you do it when no one is using the file. I've never corrupted a file by copying it when it is open, but it is possible to do so. For compacting, you may want to look at some of these KB articles: http://support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&spid=global &query=Compact+a+JET+database+from+VB&adv=&mode=s&cat=False  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > Hi Friends, > [quoted text clipped - 15 lines] > Prabhat > http://prabhatnath.blogspot.com Thanks Arvin for the reply. I will copy the DB for backup. And inmy case the DB will be local to the PC and only user will be connected. Thanks Prabhat http://prabhatnath.blogspot.com > Copying the file is the best way to back it up. Make sure you do it when no > one is using the file. I've never corrupted a file by copying it when it is > open, but it is possible to do so. For compacting, you may want to look at > some of these KB articles: http://support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&spid=gl obal&query=Compact+a+JET+database+from+VB&adv=&mode=s&cat=False > -- > Arvin Meyer, MCP, MVP [quoted text clipped - 21 lines] > > Prabhat > > http://prabhatnath.blogspot.com > Copying the file is the best way to back it up. I am informed in another forum that Access 2003 has a BACKUP option on the database utilities menu. Is this true? And, of so, how does it work? SignatureDavid W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ You were informed correctly. I never noticed it before, but it's there. It just makes a physical copy of the .mdb file, defaulting to adding the date to the file name, like "_2007-05-23". The backed up copy is an mdb file. From the help file: Back up an Access database 1.. Save and close all objects in the database. 2.. On the File menu, click Back Up Database. 3.. In the Save Backup As dialog box, specify the name and location of the backup copy. >> Copying the file is the best way to back it up. > > I am informed in another forum that Access 2003 has a BACKUP option > on the database utilities menu. Is this true? And, of so, how does > it work? > You were informed correctly. I never noticed it before, but it's > there. It just makes a physical copy of the .mdb file, defaulting [quoted text clipped - 9 lines] > location of the > backup copy. If you can tell, does it use a file copy (i.e., closes the database and copies it) or does it compact to the new filename or use some other Jet command to create the backup? SignatureDavid W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ > If you can tell, does it use a file copy (i.e., closes the database > and copies it) or does it compact to the new filename or use some > other Jet command to create the backup? > > -- Hi, I have tested the Backup procedure in MS Access. It is using the Jet Command (JRO) to Compact the Database and Copy it with the "Date" added to the DB file name. Thanks Prabhat http://prabhatnath.blogspot.com it is impossible to reliably backup an access MDB database you shoudl move to SQL Server; this has the 'maintenance plan wizard' built into the product > Hi Friends, > [quoted text clipped - 15 lines] > Prabhat > http://prabhatnath.blogspot.com Everyone please note that Aaron Kem.pf is attempting to impersonate one of our regular posters again. Tom would never post such a message. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. > it is impossible to reliably backup an access MDB database > [quoted text clipped - 20 lines] >> Prabhat >> http://prabhatnath.blogspot.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.