Linking to SQL Server

mekohler · Mar 14, 2016

Hi, I have a database in Access that acts as a front end for a SQL database. I have some forms that draw information from a SQL table and I also populate tables in the same SQL database. I would like to distribute this access database to people within my department. My question is to do with logging into the SQL database. Currently, when I start the Access database, I am prompted to login to the SQL database. When I have other users start using this database, is it possible so that they don't have to login to SQL?
Thanks,
Michael Kohler

dhookom · Mar 15, 2016

There are a couple possibilities. The ideal is to add all users to an Active Directory security group and grant the AD group read/write permissions to the database using SQL Server Management Studio. A less attractive solution is to use a DSN-less connection that embeds the login and password into the connection string.

Duane
Hook'D on Access
MS Access MVP

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!

Linking to SQL Server

mekohler

Technical User

dhookom

Programmer

Similar threads

Part and Inventory Search

Sponsor