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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Additional SQL Link Fails for Trusted Logon 6
SQL Server Error 18456 1
data acces page connect to sql server 9
SQLEXPRESS 2005 Connection Error 12
Stored procedure as row source for a combo box 4
Connect to SQL Server from A2k 4

Top