<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<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 Arthur</FONT></DIV>
<DIV><FONT face=Verdana size=2>The datafile will be a Windoze box (running XP
Pro).</FONT></DIV>
<DIV><FONT face=Verdana size=2>My concern is that for some reason the data file
isn't accessable - then how can you deal with it at the Program file end (if the
back end was an Access mdb - i'd just test the linked table, then go into a
relinker routine if the link failed) - what can you do with a MySQL
backend ?</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>Cheers Tracy</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </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=artful@rogers.com href="mailto:artful@rogers.com">Arthur Fuller</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> Wednesday, May 07, 2003 4:34
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Table links using
MySQL</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=240073216-06052003><FONT face=Arial color=#0000ff size=2>A
little more info is required, Tracy. Where does the MySQL db live? On a linux
box or Windoze? If the latter, is it a server that you have to anticipate will
be down? Or is your problem that somebody might put the db on another server?
As for me, given my druthers, since I'm using MySQL anyway I'd put it on a
linux box and hook in from there (since linux hardly ever needs to be
restarted).</FONT></SPAN></DIV>
<DIV><SPAN class=240073216-06052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=240073216-06052003><FONT face=Arial color=#0000ff
size=2>Arthur</FONT></SPAN></DIV>
<DIV><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> May 6, 2003 4:12 AM<BR><B>To:</B> Access
List<BR><B>Subject:</B> [AccessD] Table links using MySQL<BR><BR></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<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>If the MyODBC is set up correctly on the PC
with the backend MySQL data file, is there a need to test the connection
during the opening of the Access Frontend ?</FONT></DIV>
<DIV><FONT face=Verdana size=2>Or would the MySQL always be accessable
?</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>If the MySQL data file isn't available - how
do you go about relinking the files to the MySQL data file ?</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>Cheers Tracy</FONT></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>