Results 1 to 3 of 3

Thread: Linked Table Password

  1. 07-31-2003, 10:46 AM #1
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

    Linked Table Password

    Where does Access store passwords for linked tables?

    I created a linked table, changed password at the source but access was still showing records in linked table. I am sure it must have got it from its cache.

    Even when I go to Linked Table manager and refresh it does not complain about the password. Isn't this strange?
    Reply With Quote Reply With Quote
  2. 07-31-2003, 01:24 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    In the linked table manager Check "Always prompt for new location"

    Check the "Linked table"

    and click ok. this will prompt you to select the ODBC again, so that you can type in the password.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 07-31-2003, 01:28 PM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    I was thinking refresh will ask for the password.

    But still it does not explain how i can still query linked tables after changin password in SQL Server but without changing password in Access .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules