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