MS Access request username and password on every query

[Vinicius Oliveira Vinicius]

Hello guys,

I have several linked tables from MySQL on my MS Access by ODBC. I use an DNS file to make the connection.

However every time that I open the MS Access database and try open a linked table or try execute an query that use a linked table, the MySQL ODBC screen is showed requesting my user and password serveral times.

A way to minimize this problem is every time that I open the Access database file I pick a one linked table, go in Linked table manager and I force the connection with "Always prompt for new location" and select my DNS file. In this way all tables don't ask for user and password while the Access is open

Follow my DNS files bellow(I replace my user and pwd for xxxxx).

Obs: Sorry my English.

[ODBC]
DRIVER=MySQL ODBC 5.2(w) Driver
UID=xxxxxx
PWD=xxxxxx
MULTI_STATEMENTS=1
AUTO_RECONNECT=1
LOG_QUERY=1
BIG_PACKETS=1
CHARSET=utf8
PORT=3306
DATABASE=bco_dav
SERVER=10.59.144.135



Edited 1 time(s). Last edit at 08/23/2013 06:50AM by Vinicius Oliveira Vinicius.