473,321 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

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 4738
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: John South | last post by:
I have an Access 2000 front end that I wish to work with a SQL Server 2000 database by means of Linked tables. Do I have to use an ODBC connection to SQL Server? It seems to be the only option...
5
by: Arvin Portlock | last post by:
I can't come up with a query that works. Can anyone help? Conceptually the relationships are easy to describe. I have a table for books (Entries), a table for authors (Authors), and a linking...
0
by: gasturbtec | last post by:
please help im new at access programming and i just got this project dropped in my lap because the old programmer quit. i've been doing ok so far but now i need to add code to an existing database...
4
by: Konstantinos | last post by:
Asking for advise on the following. Suppose you want to build a database for handling some of your personal collections say for instance, your music collection, and your pictures collection. ...
1
by: Daveyk0 | last post by:
Hello there, I have a front end database that I have recently made very many changes to to allow off-line use. I keep copies of the databases on my hard drive and link to them rather than the...
2
by: cmd | last post by:
I use a utility database and the following code to link from an original backend to a temporary backend, in order to replace the original with a newer version: Dim dbs As Database Dim tdf As...
4
by: steve i | last post by:
Greetings; I have a project in which the client would like the database shared within an office enviornment, it is networked. My thinking is to create two databases, one with the data tables only...
1
by: lochmant | last post by:
I have a series of about 10 test databases with about 34 linked table each. I need to create an Access 2003 database front end for each of these. I am currently trying to write a script that will...
7
by: Salad | last post by:
I am converting an application from A97 to A2003. I have 2 tables created by another application as a Foxpro.dbf. The table has no index. The connect string in A97 is FoxPro...
1
by: agarwasa2008 | last post by:
Hi, I have a perfect file called "Products.xls" that I link to my MS Access 2003 database and everytthing looks good in that file. When I view the same file after linking in my database the...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.