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.
From: Bill Schwab [mailto:BSchwab@stripped]
Sent: Tuesday, 10 August 2004 11:38 AM
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
Wilhelm K. Schwab, Ph.D.
University of Florida
Department of Anesthesiology
PO Box 100254
Gainesville, FL 32610-0254
Tel: (352) 846-1285
FAX: (352) 392-7029