linking databases

[Robert Morgan]

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

[Jeff North]

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
---------------------------------------------------------------

[Jeff North]

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
---------------------------------------------------------------

[Jeff North]

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
---------------------------------------------------------------