Tracy
tracy at ak.planet.gen.nz
Wed May 7 03:21:30 CDT 2003
MessageHi Arthur
The datafile will be a Windoze box (running XP Pro).
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 ?
Cheers Tracy
----- Original Message -----
From: Arthur Fuller
To: accessd at databaseadvisors.com
Sent: Wednesday, May 07, 2003 4:34 AM
Subject: RE: [AccessD] Table links using MySQL
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).
Arthur
-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tracy
Sent: May 6, 2003 4:12 AM
To: Access List
Subject: [AccessD] Table links using MySQL
Hi Listers
Thought I'd ask:
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 ?
Or would the MySQL always be accessable ?
If the MySQL data file isn't available - how do you go about relinking the files to the MySQL data file ?
Cheers Tracy
------------------------------------------------------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030507/4f60f1c5/attachment-0001.html>