Hi all,
I have a funny issue. I have a stored procedure that opens up as a
datasheet. User can use the filter by selection option in Access to
filter records. For some reson, some of the columns cannot get
filtered. I get an error "Cannot apply filter on one or more fields
specified in the filter property". However, if I sort the stored
procedure after opening it, then I am able to filter it.
I tried removing the dbo. from the stored proc , then it works
perfectly but only for admin logins. What am i doing wrong?
-Neeta Singh
Jerry Boone - 17 Mar 2006 19:09 GMT
I recently moved my ADP to Access 2003 and that particular problem went
away! Of course it may not help if you are filtering by form on a locked
field or something.
To my astonishment, a lot of other bugs/problems went away as well. After
previously attempting to move from Access 2000 to Access XP (and having
same/similar & more problems) I was doubtful that anything would get fixed.

Signature
Jerry Boone
> Hi all,
>
[quoted text clipped - 9 lines]
>
> -Neeta Singh