Error when trying to import data into Access 2003

I'm using an external program to create and store data, and have an action button on an Access form that is supposed to import the data to the back end of my database in order to create reports etc. But when I click the Import Data button on my Access form, I get the error message on the attached file. How do I find out what is wrong to resolve it. I did not create the form or action button.
Import-Error-Access.doc
contrainAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Please post image files here (ex.: .jpg)
Image files are viewable directly in the thread.

As far as the error is concerned, you must make sure that the query exists and is spelled correctly at the time you click the button.
0
 
peter57rCommented:
Jeff has suggested a possible area to investigate and you should do that, but one of main reasons that most developers of mdb databases do not use Access macros is that there is almost no information provided when an error occurs.  The macro just stops.
That means that diagnosing a problem from a distance is pretty well impossible .
So generally all that can be said is to look through the macro definition in detail and check every entry is valid.
0
 
contrainAuthor Commented:
Good advice of how to track the macro issue. I just need to find out if it is indeed pointing to something that exists, so I'll use this advice to pinpoint the problem.
0
 
Jeffrey CoachmanMIS LiasonCommented:
<I just need to find out if it is indeed pointing to something that exists, so I'll use this advice to pinpoint the problem.>
So , then is the issue resolved?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.