How to create an interface in Access but using SQL Server as database?

I have a SQL Server database and I would like to create an interface with buttons, etc. in order to manage this more easily.

How to create and link MS Access and SQL Server?

Thank you

2 answers

  • answered 2018-05-21 13:22 pacreely

    Instead of creating an Access Database, create an Access Project.

    Google "Access Project"...or Bing.

  • answered 2018-05-21 14:05 Eperbab

    Create DSN-less linked tables without storing user & password. In the startup form's load event open a form to ask the user name & password, then run a pass-trough query with a full connection string including user and password. Access will store this connection, and reuse it for all tables linked to the same server, ODBC driver, and database.

    This example is for mysql, so the odbc string will be different: ms access; how to move it into inaccessible state / DSN-less table without password