Backing up data

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

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.
 
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.
Click to expand...

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
 
What would be the best way for me to have my dbase table
data backed up automatically into another dbase table?
Click to expand...

If you really mean dBASE, then you can simply use a DOS file copy command:

c:> copy d:\MyOldData\Something.dbf h:\MyNewData\Backup.dbf

If you mean tables with an Access database, then probably copying the mdb
file is still the easiest. The safest way is probably to copy the file to a
new location, then use Access to compact it back over the original.

If you really want to copy individual tables only, then you can use a make
table query with the IN clause:

SELECT OneField, TwoField, ThreeField
INTO BackupTable IN [h:\mynewdata\backup.mdb]
FROM MyCurrentTable
WHERE ToBeAchived = TRUE


check the syntax in the help file under the IN CLAUSE


Hope that helps


Tim F
 
Back
Top