Data Source keeps using Windows Authentication

  • Thread starter Kyle via AccessMonster.com
  • Start date
K

Kyle via AccessMonster.com

I created a data source in access to log into the SQL server back-end using
SQL server Authentication (to a user's group in the SQL server). After the
database is shut down and re-opened, the data source keeps logging in using
the user's Windows ID instead of the SQL server user's group I specified when
I created the data source.

Can anybody help?
 
Top