MS Access
"Ron" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <!&!AAAAAAAAAAAYAAAAAAAAACivnFaVHZ5Amo2nWKSDiALCgAAAEAAAAJYJ84E3ofBMnlYnlz/[email protected]> |
Sir Can the connection string format of myodbc 3.5 be used in vba code within MS Access or does one only have the option to set up an odbc data source. I have a test Access db in which I can create table links to a MySql db located on a web server using an odbc data source. However, when I try to use the connection string method, I get the 3170 ISAM error. The format of the connections string matches all the examples I can find on the web. Also, if I try to to set a reference in VBA by browsing, I am told that a reference cannot be made to the selected file. I'm new to MySql. Hence, I have downloaded the latestest versions. Thank you for any help that can be given. Regards Ron Bolton t:0117 9790233 m:07801 352638 www.baselogicsoftware.co.uk -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]