Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


"Save Password" When Creating Links to Tables in Access

"Save Password" When Creating Links to Tables in Access

"Save Password" When Creating Links to Tables in Access

I inherited maintenance of Excel tools that utilize Access databases. One of the Access databases contains nothing but links to tables in a SQL database. The SQL database administrator mentioned to me that the table names in the SQL database have changed. I am going into the Access database and creating new links to the tables.

I do not know if the original table links were created with "save password" checked when the table links were created. Is there any way for me to find out from the Access database? If I check "save password", does it also save the user name, too?

RE: "Save Password" When Creating Links to Tables in Access

Hi can only be of a little bit of help. Have just done linked database on access with MS SQL backend. Save password also saves the username. Was not using integrated login but SQL logins

RE: "Save Password" When Creating Links to Tables in Access

I believe the password is clearly visible in the Connect column of this query:


SELECT msysobjects.Connect, msysobjects.Name
FROM msysobjects
WHERE (((msysobjects.Type)=4)); 

One of my connected SQL tables has:

CODE --> Connect

DSN=QualBaseDev;Description=VCD Development;UID=xxxxx;PWD=yyyyy;APP=2007 Microsoft Office system;DATABASE=QualBase 

Hook'D on Access
MS Access MVP 2001-2016

RE: "Save Password" When Creating Links to Tables in Access

Thank you for the help on this. I had to figure out how one of our Access databases was created. It contained nothing but linked tables, and the original creator of the db was no longer available to advise me on whether he created the linked tables with passwords saved.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close