V.Urgent ODBC Problem

[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, via VBA, to the database and cannot work out how to set the option
for returning matched rows. Can i attach extra options to the connection
string - and if so how do i attach the return
matching rows option.

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


also posted to formscoding

 

[JohnFol]

If you look at the MYSQL web site it gives details of the MySQL driver you
are having the problems with

http://dev.mysql.com/doc/connector/odbc/en/manual.html#What_is_MyODBC_3.51

I'd suggest you contact the driver provider for details on how to set this
programatically.

 

[Guest]

See if this link helps.

http://dev.mysql.com/doc/connector/odbc/en/faq_toc.html#Write_conflict