Hello,
Used these boards a few times before to find answers, wondered if somebody could help me out. (Using Access 2000, and DAO Reference Library).
I have some code which used TransferText to link a series of Text files into the database. I then called a function which ran some validation through the entries imported by calling OpenRecordset with an SQL query to access the linked files (nothing complex, just a SELECT * FROM TableName command).
This was working fine. Then I decided to start working with a second database open in the same workspace. I never modified the original code, and suddenly I'm getting this issue with the OpenRecordset command. An error message comes up saying it cannot find the specified table (even though I can see it has clearly linked it by this point in the tables view).
What's weird is that when I click on Debug, it takes me to that line and highlights it, and if I use Step Through or tell the code to continue running, it then has no problem with the line and carries on until it gets to the next attempt to run the command (which would be on the next file it linked).
Does Access have some kind of time delay when linking external files into a database before OpenRecordset can access them?
If not, do I need to add some additional specifier somewhere which allow the command to more accurately locate the table?
Regards,
peridian.