Editing one table and the same table in another folder update automaticaaly.

[aligahk06]

Dear All,

I'm having a very interesting problem and lookin for solution.
I want to make a back up all records that a table may contain.
The same table and the same form with same fields,I want to update records in one form and save the records in corresponding table.
So after some time i want the same record that is saved in one table is updated in anothe table.
This table and form is in separate folder just for back up.
I mean editing in one table and auto updating in the same table in another folder.

Any help to accomplish this task.



That is one for Back up and another one for editing.


Rgds,
Aligahk06

[Robertt]

Sounds like an audit trail to me.

Are the changes being made in a form or via action queries?

If a form, and you want all of the values copied, then write a query similar to "INSERT INTO backup_table select * from edited_table where primary_key=" me.primarykey and put that in your beforeUpdate event of the form. If the event fires without a problem, good, otherwise if it fails for some reason, you can capture the error code and cancel the update of your current form before the data is changed permanently without capturing the changes.

If you are editing your data via action queries, you can use a query similar to above, but run it prior to any queries that update your data.

Just a thought, in most audit trails, only the value changed is tracked to reduce database size. This is more complex in MS Access (unless your datasource is MS SQL or Oracle) but could still be done entirely in Access with a bit of coding.

HTH,

Robert