In message <dk1tag$bv3$1@wattres.Watt.COM>, Steve Watt <steve@Watt.COM>
writes


>>Having migrated the database from SQL Server to MySQL 5 I want to use MS
>>Access 2000 as a front-end. Unfortunately none of the windows ODBC
>>drivers seem to work. The current stable release of ODBC drivers
>>silently fail without returning any data. The latest alpha release just
>>gives me an error message, it's a known bug according to the web site.
>>
>>Can anyone help me to attach MySQL 5 tables in Access 2000?
>
>I'm running MySQL 5.0.13-rc on a FreeBSD box, and was able to
>attach to it using the MyODBC 3.51.11 driver from the MySQL
>web site. It pretty much Just Worked.
>
>Uh, (ahem) with Access 2002. If upgrading is an option for you...

No, unfortunately it's not an option. But I now have it mostly working.

With the older DLL in place I can use the 3.51.12 drivers and a system
DSN, file DSNs fail. It's unlikely to be a folder permissions problem,
which was my first thought, because the SQL Server DSN in the same
folder works correctly.



--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.