Originally posted by etones
Hi all, in a bit of a pickle, hope you can help.
Assume i have 1 database with a users and a comments table, the, followign sql is fine,
SELECT u.name, c.comment FROM user u, comment c WHERE c.userid = u.userid;
Now, how could this be achived if the user table was held in a different database? How would it work?
Hi, you can achive this easily with a ms access file with linked tables through odbc or vb6 data environment designer. No matter what your database servers are as long as you have proper odbc drivers installed. This is not limitted to some databases in mysql but those in mysql and others in mssql, fox, informix, paradox...
How would it work? based upon the pre-designed linked tables/ or data environment in vb6 the tables/ databases will be automatically connected upon requests from applications.