Search results

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...