mySQL/MS Access connection/driver questions

[simon551]

Hi,
I'm trying to allow users to connect to my mysql database that is stored on a shared drive through MS Access. I've set up the user with a username and pw and set up a "file" odbc connection in the database. I can connnect using this, the driver prompts me for username and pw. no problem. But other users on the same network can't use this. They don't get the prompt for the driver/login. Could this be because they don't have the driver installed? Is there a way to run the driver from the server?

Thanks in advance!

 

[whosrdaddy]

msaccess is not a server based environment, so you need to install the ODBC driver on each client.

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[simon551]

thanks. I'll give you star when I get to a machine that will let me. --stuck in jury service