update table in another database

[Tom]

Any advice and code example on how to achieve the following would be
appreciated:

Using Access 2002 we want to be able to run a query which updates a table
field in current db and also a table field in a 2nd db held on same pc

TIA
Tom

 

[Jeff Boyce]

Tom

One approach would be to link to that second db's table and simply update it
from within your first (current) db.