By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,804 Members | 1,634 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,804 IT Pros & Developers. It's quick & easy.

Problem with OpenRecordset and TransferText

P: 72

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?

Dec 11 '06 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 14,534
It may be that you are not closing your recordsets or reseting the database.

Post the relevant code here. You can leave out any record loops or updates. Just put in brief desciption of actions that are omited.

Dec 11 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.