Scott Hamm <linuxgold@stripped> 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
