Backup Table Data

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

Does anyone know how to create a backup of table data
simultaneously as it is being recorded?

Any ideas will be appreciated.
 
Donna said:
Does anyone know how to create a backup of table data
simultaneously as it is being recorded?

Any ideas will be appreciated.
Click to expand...

It depends upon how you want to back it up. If you want to back it up to a
text file you can use I/O methods (Open #1 For Write) etc. You can also
write the date to another table using SQL (INSERT INTO tblWhatever Values
....) Or the AddNew Method:

Dim db As DAO.Database
Dim rst As DAO.Recordset

rst = db.OpenRecordset ("tblWhatever")

rst.AddNew
fld1 = Me.txt1
fld2 = Me.txt2
'... etc.
rst.Update

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top