Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC Connection 1

Status
Not open for further replies.
dk99

dk99

MIS
Jun 20, 2003
76
GB
Is there anyway to get an access database that has a ODBC connection to automatically populate the password field.

When ever I try to run a query (for the first time) it comes up with a username and password box.

Any help would be much appreciated.
 
Sort by date Sort by votes
Delete the links to your odbc tables, and recreate the links (relink the tables). When Access brings up the list of tables for you to link, make sure the "Save Password" checkbox is checked. This way, it won't prompt you for a password when you query the linked tables.
 
Upvote 0 Downvote
So Simple and yet I couldn't work it out. Thanks.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mcelligott
  • Locked
  • Question
SQL connection verification when opening database
Replies
5
Views
171
dhookom
dhookom
2rowdy
  • Locked
  • Question
Access connection prompting for a password. Error 70.
Replies
5
Views
124
2rowdy
2rowdy
bigdavidt
  • Locked
  • Question
Detecting lack of internet connections.
Replies
0
Views
72
bigdavidt
bigdavidt
chris_who
  • Locked
  • Question
Centrally documenting excel connection strings from multiple workbooks
Replies
2
Views
84
chris_who
chris_who
bradles
  • Locked
  • Question
Count current database connections? 1
Replies
5
Views
377
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top