List:MySQL on Win32« Previous MessageNext Message »
From:jbonnett Date:August 10 2004 11:15pm
Subject:RE: Access script to link many tables?
View as plain text  
Once you have set up the linked tables in Access you can go at any time into
Tools/Database Utilities/Linked Table Manager and refresh the linked tables.
This will pick up any changed table details an also give you the chance to
specify a new location if the tables have been moved.

John Bonnett

-----Original Message-----
From: Bill Schwab [mailto:BSchwab@stripped] 
Sent: Tuesday, 10 August 2004 11:38 AM
To: win32@stripped
Subject: Access script to link many tables?


I gather from reading here that an Access database used to link to MySQL
tables must be reconstructed if the table structure changes.  I have a
database with quite a few tables, and dread doing the job manually.  Do any
of you have a VBA (or whatever they call it this week) script that does such
a thing?


Wilhelm K. Schwab, Ph.D.
University of Florida
Department of Anesthesiology
PO Box 100254
Gainesville, FL 32610-0254

Email: bills@stripped
Tel: (352) 846-1285
FAX: (352) 392-7029

Access script to link many tables?Bill Schwab10 Aug
  • Re: Access script to link many tables?Webmaster - Anhinga Press11 Aug
RE: Access script to link many tables?jbonnett11 Aug