K
Kevin3NF
I have inherited an application that is MDB front-end, SQL Server BE. One
report I have is kicking the above error for some users, but not others.
Fairly complex query, but not nested queries.
My thinking is that it is more related to the System DSN I use than the
query, since it does work for some, but there is no pattern in where it
works. I am using NT Authentication in the DSN, and the NT Domain Users
group has full access to every table in SQL Server.
Other things in the db work just fine, but this report does not.
Any ideas?
Thanks,
Kevin
report I have is kicking the above error for some users, but not others.
Fairly complex query, but not nested queries.
My thinking is that it is more related to the System DSN I use than the
query, since it does work for some, but there is no pattern in where it
works. I am using NT Authentication in the DSN, and the NT Domain Users
group has full access to every table in SQL Server.
Other things in the db work just fine, but this report does not.
Any ideas?
Thanks,
Kevin