ODBC Problem

L

Louis

Hi

I know that if you link MySQL tables to an access database - you can tick
the RETURN MATCHING ROWS box. However - i have a form that appends mySQL
tables to the database and cannot work out how to do it. Can i attach extra
options to the connection string - and if so how do i attach the return
matching rows.

Thanks

AL

i.e.

connectString = "Driver=MySQL ODBC 3.51
Driver;Server=00.00.00.00;Port=3300;Database=myDB;uid=myUID;pwd=myPWD"
tdf.Connect = connectString
tdf.SourceTableName = tableList(intI)
db.TableDefs.Append tdf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

V.Urgent ODBC Problem 2
Why linked sql database is read only 2
Connect to Oracle via ODBC 5
add password to circumvent mysql connector pop-up 3
Can't update a form's ado recordset through odbc 2
DSN-Less connections with MS Oracle Driver 4
Problem with Import or Linked Tables with MySql 1
Connect Oracle Tables via ODBC and VBA 6

Top