Well...
If you are currently connected to the first database and you want to update the second database, you need to use
IN clause[
^]. Example usage of
IN
clause you'll find here:
How to: Get Data from Multiple Workbooks using One OleDbConnection?[
^]. This tip is for Excel, but you can use
IN
clause the same way in MS Access.
Note: i would strongly recommend to
link a table in the second database[
^], then you'll be able to update it as a local table.