odbc connection password issues?

[mlh407]

Hi all, I am using access as a FE for a mysql BE. I have the odbc mysql driver installed on the workstations. My issue is that I don't want the users to be able to use the driver in say excel.

I have the password saved in the odbc setup. So any application can use it. If I don't save the password in the odbc driver then access asks for the password when you open it.

Is there anyway to save that password in access (and still use linked tables), so the odbc connection can't be used else where?

Does this make sense?

Thanks,
Michael

 

[Roly Reefer]

Hi Michael,

You can save the ODBC password in Access when you link the tables. On the Link Tables window there is an option to save the password in the bottom left hand corner. This is good because it only allow access to the tables that have been checked. If somebody tries to link other tables they will be prompted for a password.

If the ODBC data source does not prompt you for a password to access the tables, this can be changed on the server. The actual ODBC data source on the PC itself should be OK to save the password in as long as you cannot access the tables without a password.

I hope this helps,


Roly