automatically add records from other database

[Davide77]

Is it possible to automatically add new records from a table of another database? Obviously the two tables have exactly the same fields and properties, but they are in different access files.

 

[kioko]

David Its very possible. there are several methods in which you can achieve this

1. Create a link table in the of the one table in the database that has the other table and update it from there

2. use dao and connect to the both database files then update the tables (Visual basic(a))
3. Use ado to and do as in 2

HTH
Francis