MySQL ODBC Connector - MyODBC functionality

Author

MyODBC functionality

Nicholas Gledhill

2006-02-25, 9:43 am

------ =_Part_16322_2870137
8.1140582604308
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64
Content-Disposition: inline

Tm9vYiBxdWVzdGlvbiA6
LSkKCkRvZXMgTXlPREJD
IGFsbG93ICJsaW5rZWQi
IHRhYmxlcyBmcm9t
IGFuIEFjY2VzcyBkYXRh
YmFzZSAocnVubmluZyBv
biBhCldpbmRvd3MgYm94
KSBpbiBhIE15U1FM
IGRhdGFiYXNlIChydW5u
aW5nIG9uIGEgTWFjIGJv
eCwgb3IgTGludXggaWYK
bmVjZXNzYXJ5KQoK
VGhhbmtzLApOaWNrLgoK
LS0KX19fX19fX19fX19f
X19fX19fX19fX18KTmlj
aG9sYXMgR2xlZGhp
bGwKRGlyZWN0b3Igb2Yg
SVQKCkRpZ2l0YWwgRGlz
dHJpYnV0aW9uIE1hbmFn
ZW1lbnQgKERETSkK
TWV0cm9wb2xpdGFuIEdy
b292ZSBNZXJjaGFudHMg
KE1HTSkKVGhlIFJpYWx0
bwozMjcgLSAzMjkg
UGl0dCBTdHJlZXQgKENu
ciBvZiBCYXRodXJzdCkK
U3VpdGUgMTgsIExldmVs
IDE1ClN5ZG5leSwg
TlNXCkF1c3RyYWxpYSwg
MjAwMC4KCigwMikgOTI4
MyA4MjUwCjA0MTkgNjAg
OTAgMjUKbmlja0B0
aGVncm9vdmVtZXJjaGFu
dHMuY29tCnd3dy50aGVn
cm9vdmVtZXJjaGFudHMu
Y29tCg==
------ =_Part_16322_2870137
8.1140582604308--

2006-02-25, 9:43 am

You can't have Access tables linked into a MySQL database but you can
have MySQL tables linked into an Access database.

In other words when using Access as your client, you can work with
Access tables and linked MySQL tables in your queries, forms etc. I
often do this when migrating data.

John B.

-----Original Message-----
From: Nicholas Gledhill & #91;mailto:nick@theg
roovemerchants.com]=20
Sent: Wednesday, 22 February 2006 3:00 PM
To: MySQL ODBC List
Subject: MyODBC functionality

Noob question :-)

Does MyODBC allow "linked" tables from an Access database (running on a
Windows box) in a MySQL database (running on a Mac box, or Linux if
necessary)

Thanks,
Nick.

--
____________________
___
Nicholas Gledhill
Director of IT

Digital Distribution Management (DDM)
Metropolitan Groove Merchants (MGM)
The Rialto
327 - 329 Pitt Street (Cnr of Bathurst)
Suite 18, Level 15
Sydney, NSW
Australia, 2000.

(02) 9283 8250
0419 60 90 25
nick@thegroovemercha
nts.com
www.thegroovemerchants.com

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc? unsu...sie.nctu.edu.tw

Bill Flanigan

2006-02-25, 9:43 am

One thing though: If you've installed the Microsoft hotfix (870753) to fix
internet syncronization of Access dbases running under WinXP SP2 (it worked
fine with SP1 and Win98) you won't be able to link MySql tables from Access
until you uninstall the hotfix. Most people don't do both: internet syncronize
their Access dbases AND link to MySql tables, so this issue is unlikely to
surface, but if you need to do both: take note!

Bill <flanigan@sopris.net>

Here's info on the hotfix and where and what it applies to:
http://support.microsoft.com/?id=870753

========

Quoting jbonnett@sola.com.au:

> You can't have Access tables linked into a MySQL database but you can
> have MySQL tables linked into an Access database.
>
> In other words when using Access as your client, you can work with
> Access tables and linked MySQL tables in your queries, forms etc. I
> often do this when migrating data.
>
> John B.
>
> -----Original Message-----
> From: Nicholas Gledhill & #91;mailto:nick@theg
roovemerchants.com]
> Sent: Wednesday, 22 February 2006 3:00 PM
> To: MySQL ODBC List
> Subject: MyODBC functionality
>
> Noob question :-)
>
> Does MyODBC allow "linked" tables from an Access database (running on a
> Windows box) in a MySQL database (running on a Mac box, or Linux if
> necessary)
>
> Thanks,
> Nick.
>
> --
> ____________________
___
> Nicholas Gledhill
> Director of IT
>
> Digital Distribution Management (DDM)
> Metropolitan Groove Merchants (MGM)
> The Rialto
> 327 - 329 Pitt Street (Cnr of Bathurst)
> Suite 18, Level 15
> Sydney, NSW
> Australia, 2000.
>
> (02) 9283 8250
> 0419 60 90 25
> nick@thegroovemercha
nts.com
> www.thegroovemerchants.com
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc? unsu...pri
s.net
>
>

----------------------------------------------------------------------
This message was sent from Sopris Surfers Webmail www.sopris.com

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc? unsu...sie.nctu.edu.tw

Sponsored Links