469,081 Members | 1,886 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

linking databases

Hi, is it possible to link databases within mysql? I have a access database
that I need to import into mysql this db consists of 4 other dbs linked
together sharing a common switchboard. Can I link the tables in one db to
tables in another db?

thanks
Bob

__________________________________________________ ______________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com
__________________________________________________ ______________________

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
3 4528
On Sat, 23 Aug 2003 16:29:50 +0000 (UTC), in mailing.database.mysql
ro*****@ihug.co.nz (Robert Morgan) wrote:
| Hi, is it possible to link databases within mysql? I have a access database
| that I need to import into mysql this db consists of 4 other dbs linked
| together sharing a common switchboard. Can I link the tables in one db to
| tables in another db?


Download the mySQL ODBC driver and install.
Open Access. Create a new db.
Select File | Get External Data | Link
Select File Type of ODBC databases.
The DSN widow opens - select (or create) your db from there.
From this point onwards you will see the tables within you database.
Just select which ones you wont.

If memory serves me correctly I don't think that Access will honor any
referential integrity that might be set (I could be wrong though, try
it, test it).
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #2
On Sat, 23 Aug 2003 16:29:50 +0000 (UTC), in mailing.database.mysql
ro*****@ihug.co.nz (Robert Morgan) wrote:
| Hi, is it possible to link databases within mysql? I have a access database
| that I need to import into mysql this db consists of 4 other dbs linked
| together sharing a common switchboard. Can I link the tables in one db to
| tables in another db?


Download the mySQL ODBC driver and install.
Open Access. Create a new db.
Select File | Get External Data | Link
Select File Type of ODBC databases.
The DSN widow opens - select (or create) your db from there.
From this point onwards you will see the tables within you database.
Just select which ones you wont.

If memory serves me correctly I don't think that Access will honor any
referential integrity that might be set (I could be wrong though, try
it, test it).
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #3
On Sat, 23 Aug 2003 16:29:50 +0000 (UTC), in mailing.database.mysql
ro*****@ihug.co.nz (Robert Morgan) wrote:
| Hi, is it possible to link databases within mysql? I have a access database
| that I need to import into mysql this db consists of 4 other dbs linked
| together sharing a common switchboard. Can I link the tables in one db to
| tables in another db?


Download the mySQL ODBC driver and install.
Open Access. Create a new db.
Select File | Get External Data | Link
Select File Type of ODBC databases.
The DSN widow opens - select (or create) your db from there.
From this point onwards you will see the tables within you database.
Just select which ones you wont.

If memory serves me correctly I don't think that Access will honor any
referential integrity that might be set (I could be wrong though, try
it, test it).
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by John South | last post: by
5 posts views Thread by Arvin Portlock | last post: by
4 posts views Thread by Konstantinos | last post: by
1 post views Thread by Daveyk0 | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.