MyODBC functionality

------=_Part_16322_28701378.1140582604308
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64
Content-Disposition: inline

Tm9vYiBxdWVzdGlvbiA6LSkKCkRvZXMgTXlPREJDIGFsbG93ICJsaW5rZWQi IHRhYmxlcyBmcm9t
IGFuIEFjY2VzcyBkYXRhYmFzZSAocnVubmluZyBvbiBhCldpbmRvd3MgYm94 KSBpbiBhIE15U1FM
IGRhdGFiYXNlIChydW5uaW5nIG9uIGEgTWFjIGJveCwgb3IgTGludXggaWYK bmVjZXNzYXJ5KQoK
VGhhbmtzLApOaWNrLgoKLS0KX19fX19fX19fX19fX19fX19fX19fX18KTmlj aG9sYXMgR2xlZGhp
bGwKRGlyZWN0b3Igb2YgSVQKCkRpZ2l0YWwgRGlzdHJpYnV0aW9uIE1hbmFn ZW1lbnQgKERETSkK
TWV0cm9wb2xpdGFuIEdyb292ZSBNZXJjaGFudHMgKE1HTSkKVGhlIFJpYWx0 bwozMjcgLSAzMjkg
UGl0dCBTdHJlZXQgKENuciBvZiBCYXRodXJzdCkKU3VpdGUgMTgsIExldmVs IDE1ClN5ZG5leSwg
TlNXCkF1c3RyYWxpYSwgMjAwMC4KCigwMikgOTI4MyA4MjUwCjA0MTkgNjAg OTAgMjUKbmlja0B0
aGVncm9vdmVtZXJjaGFudHMuY29tCnd3dy50aGVncm9vdmVtZXJjaGFudHMu Y29tCg==
------=_Part_16322_28701378.1140582604308--

RE: MyODBC functionality

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 [mailto:nick@thegroovemerchants.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@thegroovemerchants.com
www.thegroovemerchants.com

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

RE: MyODBC functionality

Nick,

If I understand your question right, then yes, Access allows "linked tables"
but they're ODBC linked tables, so they get a different icon. When you
choose to link a table, under "type" choose ODBC database (should be at the
bottom of the filetype list) and then link to your DSN. Shout if you want
more info on making a user/system DSN (or want to know what one is).

Feel free to email me direct also.

Sorry if this got answered already, I'm on daily digest.

Regards,

Al


-----Original Message-----
From: Nicholas Gledhill [mailto:nick@thegroovemerchants.com]
Sent: 22 February 2006 04:30
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@thegroovemerchants.com
www.thegroovemerchants.com


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MyODBC functionality

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

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 [mailto:nick@thegroovemerchants.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@thegroovemerchants.com
> www.thegroovemerchants.com
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=flanigan@sopris.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?unsub=gcdmo-myodbc@m.gmane.org