I have a database that is going to be used in the field for inspections. The table in that database is a copy of a table in another database on my local machine. They will update information in their table and what i would like to do is be able to run a query on that database that will update the info on my local database. for instance if hydrant pressure on their database was 100 and it is now 110 i would like the query to change that 100 number on my database to 110, i have done update queries before but never between separate databases. Thanks for your help
-
-
Macro REquery might be handy
just put the control on the row source
after update Name of macro requery
and data row source
**[db name]!"[Forms]![formname]![control]
this is the part im not sure how to do -
Put the roaming database (the one they take out with them and update with their inspection data) in a particular place on your file system, then create a linked table in your database to the table found in the roaming database. If this table is renamed to indicate it's the roaming one, then you can design your query simply to update from that table into your main one. This would be no different from using tables found in the local database.
The query would only be run in future when you put a copy of a recently updated roaming database into that position on your file system.
I presume the query details are not something you need help with. Let us know if otherwise.Comment
Comment