[AccessD] Access 2000 ADP's and DataSheet views - Crosspost

I don't know if this is the cause; just  came across it in fixes 
manifest of  Access XP SP3 just released


  ACC2002: Error Message: Cannot Apply Filter on One or More Fields That
  Are Specified in the Filter Property

http://support.microsoft.com/default.aspx?kbid=814094

This problem may occur when you connect to Microsoft SQL Server with 
credentials that are different from the credentials of the owner of the 
table that you want to filter.

Francisco H Tapia wrote:

> re-posted from the SqlServer list :)
>
> Quick questions, has anyone on the list tried to use a datasheet view 
> form bound to a view or sproc and found that if you filter out the 
> display (datasheet) that upon making changes to any field the 
> datasheet looses it's Filter?
>
> Thanks,
>

-- 
Marty Connelly
Victoria, B.C.
Canada