linking tables to mysql

[scoob8254]

im currently using a system dsn with odbc driver for mysql 5.1 to link to several tables which are in a mysql db ,

i'm wanting to make my access f/e easily distributable so was looking for a way to use a file dsn perhaps, only prob i have with this is a lot of the forms show information and do calculations based on info in the linked tables, and a file dsn doesnt seem to keep the connections to the tables open and am constanly getting promted for the user and pass, is their a way to use a file dsn or something else and have the connections to the linked tables always their till the app is closed

 

[scoob8254]

nm ive found this article which i think does what i need, ill give it a go, only issue i have is if i use doug steeles code changing it for mysql not sql


http://www.access-programmers.co.uk/forums/showthread.php?t=158159

 

[Banana]

Adapting his code is very easy; you only need to change the part for connection string and the rest of code would work. As linked in that article, you can go to Carl Prothman's site to get the full connection string you need for MySQL and put it in place where Doug builds the SQL Server connection.

One more thing you will definitely want to look at enabling options. Those are optional but I do believe you must specify "Return Matching Rows" to avoid any weirdness due to Access expecting a result of matching rows rather than MySQL's usual return of affected rows.