Filter by selection

[leighflo1]

I have developed a ADP file that i have copied to other users. When i open a view and do filter by selection on a variable everything works ok.
When i try it from another users front end, they can open the view but when they click on filter by form the following error message occurs
'One or more operators in the filter expression is invalid' press ok to that then it says
'databasename can't find the object viewname'

Can anyone help with this please?

 

[cmmrfrds]

The database owner has access to any of the database objects including views, but other users must be given permission. Do the other users have permissions on the View?

 

[leighflo1]

Thanks for your suggestion. I finally solved it by finding the error message on ms website. It wasn't an issue of permissions but one of having Microsoft Jet Service Pack 5.0

See link below.

http://support.microsoft.com/default.aspx?scid=kb;en-us;264254