auto updating tables

[wibbers2000]

Hi,
Not sure if this can be done on Access...

I have copied an existing DB from production to my my private space. I have written some new queries in this private DB and all work. I would like to move the new queries to the live environment, but not to replace the current DB. I need to prove the queries work before replacing the existing queries. I have added extra columns in my DB and I need to ensure everything works.


Is the a way that the data keyed into the existing database can automatically update the new table in real time. Or will I need to write a query to capture the data and append to the new table?

All advice is appreciated.

Regards
Wibber

[matthewspatrick]

Is the a way that the data keyed into the existing database can automatically update the new table in real time. Or will I need to write a query to capture the data and append to the new table?

In real time, no. You will either need to write queries to update, or do something like delete the tables in the production db and export your personal tables to production.