Access Make Table Query Fails

Hi Etsherman, check the references on one of your working systems and compare it to the references on the affected one.
Jake Bushnell

Much appreciated Jake.  Are you referring to the Pervasive settings on the working system when you say "references"???

Thanks,

No, I am referring to the references that Access has set. You can find them by opening your form and clicking the code button. Once you are in the VBA editor Click on Tools/ References . This will bring up a list of all the available references. The ones that are installed will have a check mark next to them. Look for any that might say "MISSING" and on the broken stations and compare the list with the Working stations.

Let me know how it goes!
Jake

Ok, that makes sense I know what you are referring to now.  I will check at the office on Friday and let you know if that was the problem.

Again, thanks.

Ok, sounds great, but if you have not got you problem solved yet you might want to un-answer this question... That would give it more time to be viewed by other experts and give me a fair chance of an A :)
Have a good evening!
Jake Bushnell

Thanks Jake,

I am new to this board.  I just realized that the message was graded.  How do you un-answer a question???

No problem!
You will need to post a Question in the Community Support Forum asking a Moderator to Un-Award it from me and make it an Open Question again. Then it will appear back in the open questions for every one to see. They are usually right on top of things there so it shouldn’t take long!

Jake Bushnell

Oh, I almost forgot! Be sure to post a link back to this question... That way the Mods know which one you are talking about!
Jake

Ok, thanks.  Actually I found the procedures under Help and I did just that.

Do you think those references could cause that error message??

Have you experienced that before????

Thanks

Yes, I once had a very similar problem with my access db in our office. Someone had been doing someone developing on a machine and changed the references. There is no guarantee that is your problem... It is just an idea! :) I also had a similar problem that was caused by the data not being available for the query, causing the query not to run but from what you said I don’t think that is you problem since it dose run on your other machines. To tell you the truth I am not very familiar with Pervasive SQL 2000. (or using access to connect to a SQL data store)
One thing you could try... Copy the application that works on one of the good stations to one of the affected stations. Of course you will probably need to refresh your data connections (or however you are connecting) and see if it still gives the same error.  That will definitely help point to the culprit.

Also, like I said earlier, be sure to open this Q open for more comments as I do not have all the answers!


Jake

Thanks Jake,

That was the first thing I tried before finding this site (copy the application from the good workstation to the one that's not working) to no avail.  Seems like it is related to something unique about the non-working workstation(s).

I will check the references though.

Thanks Jake,

Actually today I did a simple test today which confirmed where the problem is.  The Access Query errors out when reading the data tables through the ODBC connection.  Therefore, instead of linking to the data tables, I imported the data from the source data tables into Access and ran the query and it worked just fine.  So the problem is in the Pervasive ODBC driver on the workstations.  It is actually at a client's site and I advised them to make sure they have loaded out the latest SP from Pervasive and this should correct the problem since all research I have done on the subject points to a SP issue with Pervasive.

Thanks for your input.