I have a Access 97 application with data in SQL 7 and SQL 2000 db's.
I had a problem with users not being able to do a SELECT on some of the SQL tables, which i corrected by given a NT donmain group access to SELECT the tables.
After changing the SQL user permission, i changed the ODBC connection on the client machines to use NT user rights, in stead of Sql rights.
After this change the users couldn't run some of the Access reports, Access reported "Microsoft Jet could not find "Myquery" check the spelling" (Or words to that effect).
My Db is a Access MDE file.
When I connect to the db everything is working. I suspect it to be a user right problem? But where? SQL or Access?
Does anyone have any idea?
Regards
Christoffer
I had a problem with users not being able to do a SELECT on some of the SQL tables, which i corrected by given a NT donmain group access to SELECT the tables.
After changing the SQL user permission, i changed the ODBC connection on the client machines to use NT user rights, in stead of Sql rights.
After this change the users couldn't run some of the Access reports, Access reported "Microsoft Jet could not find "Myquery" check the spelling" (Or words to that effect).
My Db is a Access MDE file.
When I connect to the db everything is working. I suspect it to be a user right problem? But where? SQL or Access?
Does anyone have any idea?
Regards
Christoffer
