Backup Table Data

[Donna]

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

Any ideas will be appreciated.

 

[Arvin Meyer]

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

Any ideas will be appreciated.

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