brotherkennyh
Member
- Joined
- Jun 18, 2013
- Messages
- 11
- Programming Experience
- Beginner
Hi,
I want to be able to create query's based on two tables that are in different databases, particularly update and insert queries.
In access it is possible to add the remote table as a linked table, in all queries the remote table can be treated and accessed with the same syntax as local tables. Can I do something like this in vb?
Both my databases are MySQL databases. One is on a local Linux server and the other on a web server.
Cheers
Kenny
I want to be able to create query's based on two tables that are in different databases, particularly update and insert queries.
In access it is possible to add the remote table as a linked table, in all queries the remote table can be treated and accessed with the same syntax as local tables. Can I do something like this in vb?
Both my databases are MySQL databases. One is on a local Linux server and the other on a web server.
Cheers
Kenny