Wildcard Characters

[John]

I'd like to be able to use wildcard characters in a query. I followed the
instructions listed on kb 826992 http://support.microsoft.com/kb/826992

I am using Infopath 2003
however I keep getting an error message:

The following error occurred:

InfoPath cannot open the following view: Data Entry
An item with the following index does not exist in the collection: Data Entry

File:script.js
Line:83

 

[Ben Walters]

Hey John,
Personally I wouldn't connect directly to a SQL database, have you tried
using a web service as your intermediate connection to your SQL backend?

 

[John]

I'm trying to connect to an Access Database, not SQL. I wasnt planning on
running a web service for this project. I guess there is no other way to use
wildcards? The directions from MS only work if you are using a web service?

 

[Hilary Stoupa]

Hi, John.--

The very end of the code sample you've referred to switches to a view called
'Data Entry'. Do you have a view with that name?