Re: Backing up data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 12/03/04


Date: Fri, 03 Dec 2004 11:01:43 -0700

On Fri, 3 Dec 2004 07:14:17 -0800, "Todd"
<anonymous@discussions.microsoft.com> wrote:

>What would be the best way for me to have my dbase table
>data backed up automatically into another dbase table? If
>someone could guide me in the right direction I'd
>appreciate the help.

Are you talking about a dBase table (an external .dbf file)? or are
you talking about a Table in an Access database (.mdb file)?

If you're talking about Access Tables, they have no independent
existance outside of a Database. It's best to back up the entire .mdb
file; be sure that nobody has the database open at the time and use
simple file copy in Windows Explorer to copy the .mdb file to a backup
medium (such as a CD or network disk).

                  John W. Vinson[MVP]
             Join the online Access Chats
        Tuesday 11am EDT - Thursday 3:30pm EDT
      http://community.compuserve.com/msdevapps



Relevant Pages

  • Re: D-Base versus Access
    ... dBase .DBF files were a very ... Access objects and data, by default are stored in Jet .MDB database ... files, which can hold 2GB, plus the Access database can be linked to tables ... keeps all its objects within the .MDB and linked .MDBs. ...
    (microsoft.public.access.formscoding)
  • Re: ADOX - Import type library into Delphi 2007
    ... I want to modify an Access database at runtime and this takes ADOX (not only ADO but also ADOX so you can f.ex. ... I might add that I have been given the suggestion to rename the MDB file, create a new table, create a new table and them migrate the data from the old file to the new. ...
    (borland.public.delphi.database.ado)
  • Re: Working with text database in an asp page?
    ... then why not use Access database as the data source? ... I would love to use a mdb file but I am receiving this as text ...
    (microsoft.public.frontpage.programming)
  • RE: Check for table
    ... If the mdb file cannot be moved I suggest you use SqlDataSource instead of ... Access database, but by the invalid path specified for the AccessDataSource ... After the exception is eliminated we can still use the code I provided ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: MS Access OLEDB connection problem
    ... Cannot connect to Access database from ASP.NET ... "Grant read and write permissions for the "Everyone" group on the database ... >> where the .mdb file is located. ...
    (microsoft.public.dotnet.framework.aspnet)