Jim Lawrence (AccessD)
accessd at shaw.ca
Sun Apr 27 01:54:47 CDT 2003
Hi Tracy: It is pretty straight forward if you are using ODBC or better yet, ADO-OLE already to connect to the MBD BE. If not you will have to set up same. The SQL query syntax is a little different; more like MS SQL. (i.e.. % instead of * with the 'like' operand etc...). You can always direct you requests towards Arthur Fuller is apparent expert in MySQL or I can try and help. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tracy Sent: Saturday, April 26, 2003 2:24 PM To: Access List Subject: [AccessD] Access to MySQL Hi Listers Thought I'd ask: I've downloaded MySQL Ver 4.0.12 (Windows 2000) I'm starting to migrate my backend data file to MySQL. Does anybody have any tips for things to watch for ? I will be maintaining both Access and MySQL for a while (just in case) Cheers Tracy -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030426/31eba9d1/attachment-0001.html>