MontyBurns
Programmer
Hi,
A bit of an urgent one unfortunately...
10 days ago I released a new version of a frontend DB, and forgot to update the linked-table links. The copy of the backend DB I was using for development was very much out of date. This means that an out of date copy of the DB has been receiving all the updates etc for the past 10 days while the actual live DB hasn't been touched.
So I need to run a program which updates all the data from my old Dev copy, to the Live .mdb. (only recs which have changed in the past 10 days.)
The main table has a DateAmended field thankfully, but none of the sub-tables do, and I can't be sure at this moment if the sub-forms are updating the main table when they're updated.
If anyone has any tips or gotchas I should be aware of, please let me know. Also, and more specifically, when I open a recordset does each row have a datestamp I can check? And is this reliable?
Thanks,
Burns
A bit of an urgent one unfortunately...
10 days ago I released a new version of a frontend DB, and forgot to update the linked-table links. The copy of the backend DB I was using for development was very much out of date. This means that an out of date copy of the DB has been receiving all the updates etc for the past 10 days while the actual live DB hasn't been touched.
So I need to run a program which updates all the data from my old Dev copy, to the Live .mdb. (only recs which have changed in the past 10 days.)
The main table has a DateAmended field thankfully, but none of the sub-tables do, and I can't be sure at this moment if the sub-forms are updating the main table when they're updated.
If anyone has any tips or gotchas I should be aware of, please let me know. Also, and more specifically, when I open a recordset does each row have a datestamp I can check? And is this reliable?
Thanks,
Burns
