troubleshooting Question

Stuck with untrappable error in Access app

Avatar of Bernard Thouin
Bernard ThouinFlag for Switzerland asked on
Microsoft Access* ADO
8 Comments1 Solution90 ViewsLast Modified:
Hi

I get a weird error in an Access app which was working before, when starting the main form, which is trying to bind to a remote DB2/400 DB using a connection string and ADO.

The error is "Could not find file 'C:\Users\MyUser\Documents\<DB2 DB name>.mdb'

And it happens BEFORE anything else, before the form Load or the Form Open event, I cannot trap it although I have set break points on the first statement of each routine in the form ! It's extremely frustrating. Even more frustrating is that the form worked, not quite as I wanted, I changed something, I can't remember what, and now this happens and I am totally stuck.

I had this error once when qualifying the table name I'm trying to bind to the form with the DB name, but now, regardless if I qualify or not the table name, it bombs out, and even before any code has been executed, seemingly !

Anyone can help ?

Bernard
ASKER CERTIFIED SOLUTION
Bernard Thouin
IT Analyst and developer

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 8 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 8 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