Scott Hamm <[EMAIL PROTECTED]> wrote on 10/18/2005 09:46:20 AM: > Is there a way I can create a table on MySQL using Access and > establish a link remotely? > -- > Please avoid sending me Word or PowerPoint attachments. > See http://www.gnu.org/philosophy/no-word-attachments.html >
You can write some VBA code to send to MySQL the CREATE TABLE command through an ADODB.Connection object. After that, you will need to figure out how to create a linked table programmatically as I have never tried. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
