Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
usr123
Starting Member
12 Posts |
 Posted - 2010-02-09 : 07:28:02
|
| Hello All,I am working with microsoft access and SQL server 2005. Have got database in Sql Server 2005 and forms in Access 2007. I am connecting these forms through ODBC connection. One thing i noticed that in order to make user available working in these front ends, i have to make ODBC connection working which in turn needs admin rights for the user on the database in question. Now as i dont want to give users admin rights, how can i still make ODBC connection and get them connected to the database to perform all the functionality which access front end provides.Any help is greatly appreciated. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-09 : 09:33:43
|
| why does user need admin rights? what is the front end doing? if it's just reading/writing data, it does not need admin permissions. |
 |
|
|
|
|
|
ODBC connection