<!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.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Verdana size=2>Hi Jim</FONT></DIV>
<DIV><FONT face=Verdana size=2>Thanks for your reply.</FONT></DIV>
<DIV><FONT face=Verdana size=2>I've found one little glitch...on opening a form
I had (in Access) a Where clause...WHERE tblClient.Deleted=No</FONT></DIV>
<DIV><FONT face=Verdana size=2>Using MySQL this didn't evaluate and the client
form was empty.</FONT></DIV>
<DIV><FONT face=Verdana size=2>But changing the Where clause to...WHERE
tblClient.Deleted=false seemed to work.</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>I guess its just a matter of going thru things
bit by bit and changing what I need to.</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>Cheers Tracy</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=accessd@shaw.ca href="mailto:accessd@shaw.ca">Jim Lawrence
(AccessD)</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, April 27, 2003 6:54
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Access to
MySQL</DIV>
<DIV><BR></DIV>
<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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>