troubleshooting Question

InfoPath 2003 Query returning no values

Avatar of jefjar
jefjar asked on
InfoPath
2 Comments1 Solution392 ViewsLast Modified:
I have created a form that uses the customer number in a query field to return customer and equipment data.  The data resides in a 2003 access database table named "Customers."  When I previewed the form the first time I had no problem populating data.  The second time I tried it I recieved an error message stating no query data was found.  Not True, data exists.

I deleted the data link, recreated it, restablished my bindings and tried again with no luck.  I then copied the SQL statement from InfoPath and pasted it into excel and tried to pull up the data with success.  

I'm stumped now.  I've looked at the forms permissions and nothing has changed since I created it.  

Any ideas on what to check next?
ASKER CERTIFIED SOLUTION
Clay Fox
Director of Business Integration

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros