Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2004-12-16 : 12:12:28
|
| I know this site is a SQL-Server dedicated but probably one might have an experience with this problem and can give me some hints.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 messageFilter criteria when using Office 2000: "*12345*"and it bring the record. Filter criteria when using Office 2003: "*12345*"and it doesn't bring anything.Any idea about the issue with Office 2003? Canada DBA |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-12-16 : 12:14:41
|
| probably need to use % instead of * for the wildcard.- Jeff |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2004-12-16 : 12:37:29
|
It shouldn't be because a new version usually supports the older versions. But I tried your suggestion and it doesn't work.quote:
Originally posted by jsmith8858
probably need to use % instead of * for the wildcard.- Jeff
Canada DBA |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-12-16 : 13:42:02
|
| Do you think giving us more information might be helpful?- Jeff |
|
|
|
CanadaDBA
583 Posts |
Posted - 2004-12-16 : 14:03:41
|
| Here is more discussion: I load the form. It shows 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?Canada DBA |
|
|
|
CanadaDBA
583 Posts |
Posted - 2004-12-16 : 14:44:34
|
| The form is result of some tables join. I think office 2003 loads everything in memory and when the user is setting filter using R-Click, there is no call to my SP which provides the information. In other words, Office 2003 is looking within the 21281 records for a match that it has already in memory. This should be the same with office 2000. Probably, office 2003 is smarter than 2000 version and doesn't provide info for R-Click filters.Canada DBA |
|
|
|
|
|
|
Filter problem in Office 2003