I have two identical Databases - one is a Live DB and the other is a Training DB. The data is held on a sql server connected to an access front end. (I do not have access to the sql server).
- On each table I have a field called UpdatedOn
- On each table every record has one field that is a unique ref. But the name of each field containing the unique ref is different on each table
- There are about 100 table to loop through.
What I need is some code that will loop through each table and each record, and where the UpdatedOn field on the live DB is not equal to the UpdatedOn on the training DB - update the whole line on the training DB with the Live DB data using the unique ref
I intend to only have one access client and import the sql tables from the Live and Training into the one. Therefore for example sqlMyTable will be live DB and sqlMyTable1 will be the Training DB
If anyone has a better way - please feel free to say.
Hope someone can please help
Thanks
Jason
- On each table I have a field called UpdatedOn
- On each table every record has one field that is a unique ref. But the name of each field containing the unique ref is different on each table
- There are about 100 table to loop through.
What I need is some code that will loop through each table and each record, and where the UpdatedOn field on the live DB is not equal to the UpdatedOn on the training DB - update the whole line on the training DB with the Live DB data using the unique ref
I intend to only have one access client and import the sql tables from the Live and Training into the one. Therefore for example sqlMyTable will be live DB and sqlMyTable1 will be the Training DB
If anyone has a better way - please feel free to say.
Hope someone can please help
Thanks
Jason