Hi - I have an Access ADP front ending a SQL Server 2000 database. This has been working fine for some time but I now have a problem that I have spent many days trying to fix in vain.
The problem revolves around using the filter lookup property on some textboxes on the Access forms. When I use the form everything works fine as I am an administrator (we use NT Authentication on SQL Server) but when a normal user tries to use it they just get the 'NULL/IS NOT NULL' default values.
I have read many posts and have made sure that the record source qualifier is set to 'dbo' and have used SQL Profiler to trace what is happening. I believe the problem lies somewhere with the permissions that normal users have (or don't have!) but I can't see what.
The Profiler trace showed that a temporary SQL table is created by a system stored procedure (sp_MShelpcolumns) and my account inserts records into it whereas a user account doesn't.
Anyone got any ideas??
The problem revolves around using the filter lookup property on some textboxes on the Access forms. When I use the form everything works fine as I am an administrator (we use NT Authentication on SQL Server) but when a normal user tries to use it they just get the 'NULL/IS NOT NULL' default values.
I have read many posts and have made sure that the record source qualifier is set to 'dbo' and have used SQL Profiler to trace what is happening. I believe the problem lies somewhere with the permissions that normal users have (or don't have!) but I can't see what.
The Profiler trace showed that a temporary SQL table is created by a system stored procedure (sp_MShelpcolumns) and my account inserts records into it whereas a user account doesn't.
Anyone got any ideas??