Search results

Just figured it out, I used SQL script to create my new groups, and when they were created, they were disabled. Not completely sure why yet, I didn't have any DISABLED statements in there. Some groups were created ENABLED though. Once I enable those accounts, I think I'll be good to go. So it...

That's the way I'm starting to lean now too. I've ran SQL Profiler and verified the login being passed, and it definitely is passing the current logged in user. I've still got some testing to do, but I don't think Access or ODBC is the problem. Thanks for the comments.

Thanks for the reply. I've made sure the new group mirrored the permissions of the old group, and that is what I'm having trouble with. The old group was actually Domain Users that had datareader, and a new group with a few individuals who actually needed direct access to the database were the...

Hi all, Quick question: I'm trying to understand using an ODBC connection through MS Access and Excel just a little bit better. Our ERP vendor uses MS Access to report, and when it's installed, they create an ODBC connection to the database. The ODBC connection is set to use SQL logins, not...