J
JOE
Anyone seen this?
WIN2000, Access 97 SP2. ODBC DSN - SQL Server 7 & 2000
When I created all the DSNs I checked to prompt for DB
login each time.
Just recently it started acting quirky and now
no matter what DSN I choose (in Access), it always
attempts to connect using Trusted connection first instead
of prompting me for the DB password(s). It always fails, I
then have to uncheck it and type in the password at the
prompt that I wanted in the first place.
It is like some (Windows) default flag got changed to
alway use the trusted connection.
How can I change this back?
Does this require registry editting, cause I don't really
know how.
TIA
WIN2000, Access 97 SP2. ODBC DSN - SQL Server 7 & 2000
When I created all the DSNs I checked to prompt for DB
login each time.
Just recently it started acting quirky and now
no matter what DSN I choose (in Access), it always
attempts to connect using Trusted connection first instead
of prompting me for the DB password(s). It always fails, I
then have to uncheck it and type in the password at the
prompt that I wanted in the first place.
It is like some (Windows) default flag got changed to
alway use the trusted connection.
How can I change this back?
Does this require registry editting, cause I don't really
know how.
TIA