SQL server login does not appear

A

angel

I do not know if this question was asked before.
When I tried to link my access database to a SQL database,
the SQL server logon window does not show up.
In the past it used to pop up the first time I tried to
access a table already link or when I needed to get
another table.

I know I did not select any automatic logon or save
password.

Any help is greatly appreciated,

Thanks
 
J

Joe Fallon

Access does cache the credentials on linked tables.
If you view the properties of the linked table you will only see part of
them!
The passwrod is not displayed.

So you (or someone) probably linked the tables and used credentials that
allow you to re-open them without re-authenticating.

A simple test would be to create a new mdb and link to the server. You
should get prompted.
If you don't then your network probably has Windows authentication set up
and you can get in.
Try it from some other users PC who does not have access to the server and
it should fail.
 
A

angel

Thanks for your input/help, Joe.

Is there a way to clear the cache credentials, so that it
prompts for a password?

I tried what you told me, I actually disable my account on
the SQL server. It first gave me an error message and then
prompt me for userid and pswd.

Thanks,
Angel
 
J

Joe Fallon

I always delete all linked tables and re-create the links.
Clearing the cache is one of the many benefits of this strategy.

(I have posted sample code for this hundreds of times so just do a quick
check.)
 
Top