ODBC Administrator requires admin rights?


New Member

I support a fleet of about 600 Windows XP machines that will soon be upgraded to Windows 7. We've begun limited testing and I've encountered the first problem related to the heightened user restrictions. A user cannot administrator ODBC settings without local admin rights. Is there any way around this? Our users are regularly adding/editing/deleting, ODBC data sources in order to create reports and queries from SQL databases, and making our users local admins is out of the question. Even when I make a user a Power User, it's still asking for an admin name and password.

This particular user is on Windows 7 Enterprise 64bit.

This website is not affiliated, owned, or endorsed by Microsoft Corporation. It is a member of the Microsoft Partner Program.