|
-
Apr 30th, 2001, 09:19 AM
#1
Thread Starter
New Member
Jet Engine Problems
Help!
Upon creating a New instance of an Access.Applcation and then using the code:
With appAccess
.OpenCurrentDatabase gstrDatabasePath 'Open DB
.DoCmd.TransferText acImportDelim, , "tblRawTemp", gstrFilePathToOpen, True
.CloseCurrentDatabase 'Close DB
.Quit
End With
I occasionally receive the following error when the code hits the .DoCmd line, however the table does exists and is spelt correctly. It seems to work more often when I insert a breakpoint on the .DoCmd line.
Does anyone know the source of this error and how to resolve it?
Error # -2147217865 was generated by Microsoft JET Database Engine
The Microsoft Jet database engine cannot find the input table or query 'tblRawTemp'. Make sure it exists and that its name is spelled correctly.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|