I am trying to use Ad Hoc Queries to load data from incoming Access files. I can make the procedure work with my login, but when I use another login that does not have sql sysadmin permissions, it says I do not have permissions to run that query. I have made sure the permission to run distributed queries is turned on both in SQL Server and in the registry. The test user does have owner permissions on the database with the procedure, tables, etc..
Any help is greatly appreciated.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.