[MS_AccessPros] Users cannot connect to SQL tables

 

Hello friends,

I'm new to SQL server so I need some help. I just migrated my ERP software to SQL Server. I have an Access 2007 front end linked to some of the tables in it. My users cannot connect to the linked tables. It is an authentication issue. I setup an OBDC connection that works fine for me but then I'm the DBA. How do I set them up permissions to authenticate to SQL. I have an active directory user group that I'd like to assign rights, however, I don't how to do that in SQL server management console. It is version 2008 R2.

Doyce

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 9
• New Files 5

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___