<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=080504506-27042003><FONT face=Arial color=#0000ff size=2>Hi
Tracy:</FONT></SPAN></DIV>
<DIV><SPAN class=080504506-27042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=080504506-27042003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=080504506-27042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=080504506-27042003><FONT face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=080504506-27042003><FONT face=Arial color=#0000ff
size=2>Jim</FONT> </SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of
</B>Tracy<BR><B>Sent:</B> Saturday, April 26, 2003 2:24 PM<BR><B>To:</B>
Access List<BR><B>Subject:</B> [AccessD] Access to MySQL<BR><BR></FONT></DIV>
<DIV>
<DIV><FONT face=Verdana size=2>Hi Listers</FONT></DIV>
<DIV><FONT face=Verdana size=2>Thought I'd ask:</FONT></DIV>
<DIV><FONT face=Verdana size=2>I've downloaded MySQL Ver 4.0.12 (Windows
2000)</FONT></DIV>
<DIV><FONT face=Verdana size=2>I'm starting to migrate my backend data file to
MySQL.</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>Does anybody have any tips for things to watch
for ?</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>I will be maintaining both Access and MySQL for
a while (just in case)</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>Cheers
Tracy</FONT></DIV></DIV></BLOCKQUOTE></BODY></HTML>