Connect Access Project to mySQL

[Raghu]

I have a mySQL back end....need to connect my Access Forms
programmed as a Prouct.ade file (from Product.adp) that
previously connected to SQL Server (to save using up SQL
server licences on our very small databases). Now I need
to redirect the forms in Product.ade to mySQL database,
please someone shed some light on how to do this....
Thanks

 

[Larry Linson]

Unfortunately, Access Data Projects (aka ADP/ADE, aka Access Projects) are
only compatible with Microsoft SQL Server. Access MDB/MDE, using MyODBC, and
linked tables are compatible with MySQL. Unfortunately, there is no
"translator" to convert your ADP/ADE to MDB/MDE form.

And, if all you have is the ADE, not the ADP, your code is "locked down"
anyway and you will have to re-created it.

Larry Linson
Microsoft Access MVP