microsoft jet database engine could not find the object"

  • Thread starter Thread starter WFH
  • Start date Start date
Hi,
this message refers to different things for different types of import files.
What type of program made the file you are trying to import?
If you are trying to import an .xls file, this error can appear if you are
using the named range argument in either the wizard or Transfer Spreadsheet
and access can't find the named range.

Jeanette Cunningham
 
Hi,
if you meant an access database table, here is the help from the microsoft
website.

You may receive this error message if Access cannot find the table or the
query in the database, if a link points to an external file that does not
exist, or if the external file has been moved to a new location. This error
can also occur if a deleted or renamed table or query is referenced on the
Lookup tab of another table.
Back to the top

To troubleshoot this behavior, do the following:
.. Check to ensure that the table or query exists. If it does not exist, you
can remove all references to it, or if it is a missing table, reimport or
relink the table. If it is a missing query, reimport or re-create the query.
Often the RecordSource property of a form or a report contains a reference
to a table or a query whose name has changed or which has been deleted.
.. If the table or query exists, it is likely that there is a syntax error or
a spelling error in the reference to it. If so, correct the syntax error or
spelling error in the reference.
.. When you try to open a linked table, the source table may not be in the
path that you specified when it was first linked. If you have moved the
file, you can use the Linked Table Manager to update the link information.


Jeanette Cunningham
 
Jeanette, thanks for the help. Still unsure as to the reason. The original
file is a txt file. I received the file in a .PRT file format that I opened
with wordpad and then saved as a txt file. Any Ideas?
 
I found this website about .prt files, maybe it will help.


Jeanette Cunningham
 
Jeanette, thanks for the site. Funny...I read your comment to the next
question only. I actually have built a Access Import Spec, and when I try to
use that is when I get the error report. I've looked at it several times and
can't find where I might have messed it up. Any other ideas?
 
YEAH!!!
Jeanette, got to looking at my import spec, dummy me, I had a text field
with a length of 500 characters. I changed it to a memeo field and it
worked. Thanks for taking the time to answer my questions!
 
Back
Top