Results 1 to 2 of 2

Thread: Linked sql table always requesting logins

  1. #1
    Join Date
    Oct 2002
    Posts
    34

    Linked sql table always requesting logins

    Scenario:
    There was no problem until a SQL table link was deleted and relinked.

    Now, on a machine specific basis, Access asks that the user log in to SQL Server everytime the table is accessed for the first time.

    I've tried recreating the dsn and relinking the table over and over but the problem still manifests itself in the same fashion.

    Any new ideas would be appreciated.

  2. #2
    Join Date
    Oct 2002
    Location
    San Fran
    Posts
    6
    Use a file DSN as opposed to user or system DSNs - be sure to check SQL Authentication within the DSN. Also check with SQL admin that all non-admin login roles have been properly set within sql server.

Posting Permissions

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