Access Front end + Remote MYSQL Server - Issues

[Graeme Simpson]

Hi,

Really am a total novice with both Mysql and MS Access, but have been put in the spot where I need to get a workstation up and running and talking to Mysql.

Mysql is running on a linux server.

Workstation is Windows 7 x64 with MS Access 32bit.

So I configured the connector in Admin Tools/Database Sources/SystemDSN

I can hit the test button and it connects to the server fine and confirms the account is fine.

Running the access front end, works fine until I hit a task to get data, I then get an "obdc failed to connect" (Or similar).

Its as if I have missed a step somewhere.

Done so much reading, its now begining to make confusion an doubt set in.

Any kind member out there, could offer any advice, it would be very much appreciated.


Thanks