MS Access link table issue

Shabbir K Kanore 21 Reputation points
2022-06-19T05:05:59.793+00:00

Hello,

I have a MS Access application which has link table from SQL Server Database (Express Edition). Now, the issue is, on some users pc its ask for SQL Server password while on some it does not. I linked the SQL Table with password saved. Its creating issues with users setup. Thanks

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
898 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Albert Kallal 5,496 Reputation points
    2022-06-22T19:47:37.75+00:00

    Ok, I try and keep this short.

    I suggest that you attempt to re link the tables, but WHEN you create the links, two things to note:

    First up, MAKE SURE you link the tables using a FILE DSN. it turns out if when you from access launch the odbc connection system, it defaults to FILE. So, do NOT create this ODBC link from the control panel, but do this from access.

    don't create/use a "user dsn" and do not create a "system" dsn. Make sure you choose FILE for the connection.

    This one:

    214051-image.png

    Next up, be 100% sure, in fact 200% sure, when you linked the tables you select this check box:

    this one:

    213993-image.png

    If you follow the above, then you can distribute this applcation (often called front end) to each work station and it should just work, just connect, and should not prompt users for a logon.

    And you do NOT get that [x] save password when you re-link - ONLY first time you create the table links, so you may well have to re-create the links.

    The other issue of course is the ODBC driver you choose. You can choose the built-in long time "legacy" "SQL Server driver", or you can choose a newer and later Native 11 - 17 (or even 18) now. But, if you link using a newer driver, keep in mind that these newer drivers are not installed on all work stations by default, and thus you HAVE to install that same driver on each work station for this to work.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.