Update data from another database

[Ishaw]

Hi Guys,



If I wanted to update data that is in a table from another database how would I do that using VB.

What I want to do is, update a value in a table and then once that value is saved , update that record if it exists in another database. All I need to know is how to log into the other databse. I know how to do the search and the actual update but I just need to know how to log into the database so that I can then do the seach for the particular record and then do the actual update.

Does anyone know how to do this using VB say a function maybe?

Many thnaks in advance,

Cheers,
Ian

[msr71]

Try creating a link to the table you want to update and refer to the link in your update statement.

[ssanfu]

Here are three links that might help you. I think the first is the most relevant to your question.


http://www.rogersaccesslibrary.com/forum/topic276.html

http://www.rogersaccesslibrary.com/forum/topic338.html

http://www.rogersaccesslibrary.com/forum/topic334.html

[Ishaw]

Hi Guys,

Thanks very much for your responces, I shall check them out and let you know how I go to resolve my updating of the databse issues!!

Many thnaks again!

Ian