open another database

[DMT Dave]

Hi guy's, how do i open another database and add data to a table but have the 2nd database not visible ?

db1 to open db2 and add data to to a table with the same field names thn close the database from a message box ie:

rsdb1 = etc etc
rsdb2 = etc etc
Do Until rsdb1.EOF
rsdb2 = rsdb1.Fields etc etc

If Msgbox("You have sucessfully updated db2, Do You want to view the updates or close db2 ?") = vbNo Then
DoCmd.cancel
Else
close db2
End IF

I haven't actually coded this yet but hoping to very shortly

much appreciated

[isladogs]

While it is possible to open another database, append or update records then close it, I've never yet heard a good reason for doing so.
There is a simple alternative readily available to you.
Link the table(s) that you wish to update.
Run your append/update query/queries/sql.
Job done.

If you really want to do so, you could break the links after the update but why bother?