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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-19 : 15:29:47
|
Abdel writes "Hello all,
I Developed an Access Database project (.adp)
using MS Access 2000 & MS SQL Server 7,
I used Windows NT Authentication to log to the database,
so I created the logons to the SQL Server Database with DB_reader
and DB_writer for all users, one user was also assigned as a local Administrator on the SQL Database server (NT Administrator)
Later when this user was removed from the NT Local Administrator
Group he was not able to view the reports (Access 2000 reports)
the error message was that the query that report is trying to execute is not available or does not exist although he can view the same data from Access form & can execute the same query that the report claims it does not exist, all other users can see the report/s , further more if that particular user created a record he can view it even if he created the same report he can view it, when he was reassigned to the NT Local Administrator he could view the reports,
Please help,
Thank you for your time,
Abdel"
|
|
|
|
|
|
MS Access Database project (.adp) , MS SQL 7 , NT Security