Thanks for the reply SQL_Hell but I don't think this is where the problem lies as the query runs fine regardless of who runs it.
Let me explain a bit more....
The Access form uses a stored procedure as it's underlying record source - this actually runs ok whether as myself or as a normal user...
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...