Filter problem in Office 2003

[Guest]

Our applications are Access with SQL-Server. Recently, they are upgraded to
Office 2003. Here is the problem with an example:

Filed data: 12345 Test message

Filter criteria when using Office 2000: "*12345*"
and it bring the record.

Filter criteria when using Office 2003: "*12345*"
and it doesn't bring anything.

I load the form. It showes that 21281 record is loaded. I can browse. If i
R-Click on a field and Filter For something, it brings up all records match
to that criteria. If I use * in that criteria, it doesn't show anything. This
happens while I can do the same in Access 2000 and it brings filtered
records. How come?

 

[Allen Browne]

If the data is attached from SQL Server, try a % as the wildcard instead of
*.

 

[Guest]

It is attached to SQL-Server but when the user is using R-Click, there is no
call to the SP that is providing the data from some JOIN and UNION of SELECT
statements. It seems Access 2000 brings up filtered data from the record set
in memory (not from SQL call) but Access 2003 is intelligent and don't do it.
But I am just guessing! Not sure about it.

 

[Allen Browne]

No, I can't give you a definative answer either.

The behavior might even be affected by what you have set under:
Tools | Options | Tables/Queries | SQL Server Compatible Syntax.