DBF and DB Import Error

[Dave McDonald]

I get an error message stating "The Microsoft Jet
Database Engine could not find the object "Name.db".
Make sure the object exists and that you spell its name
and the path correctly."
I have copies of DBF and DB files on my local PC. Excel
can open the DBF file with no problem. Also, I can use
conversions plus to convert the DBF to a delimited file
for import.
OS: Windows XP Professional; Office XP (Version 10.0)
There is a note about ISAM drivers, but all I need to do
is convert the files into a table in Access; not to write
to it.

Thanks for your help.

 

[John Nurick]

Hi Dave,

One possible cause is long filenames. AFAIR Access requires (for old
times' sake, one presumes) that dbf files have old-fashioned "8.3" short
names and that the length of the path and filename combined do not
exceed 64 characters. For others, search the Microsoft knowledgebase at
http://support.microsoft.com/default.aspx?scid=fh;en-gb;kbhowto

I get an error message stating "The Microsoft Jet
Database Engine could not find the object "Name.db".
Make sure the object exists and that you spell its name
and the path correctly."
I have copies of DBF and DB files on my local PC. Excel
can open the DBF file with no problem. Also, I can use
conversions plus to convert the DBF to a delimited file
for import.
OS: Windows XP Professional; Office XP (Version 10.0)
There is a note about ISAM drivers, but all I need to do
is convert the files into a table in Access; not to write
to it.

Thanks for your help.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[Khalid]

I used to link tables from AS400 library into Access and
get this error because I used dot notation, for example
AS400DB.TableName.Field which caused the same error you
are getting. Access fails because it cannot refer to the
AS400DB directly. But after linking the table and using
DB_TableName.Field which is the actual name of the linked
table, it workes.

Hope this helps
Khalid

-----Original Message-----
Hi Dave,

One possible cause is long filenames. AFAIR Access requires (for old
times' sake, one presumes) that dbf files have old- fashioned "8.3" short
names and that the length of the path and filename combined do not
exceed 64 characters. For others, search the Microsoft knowledgebase at
http://support.microsoft.com/default.aspx?scid=fh;en- gb;kbhowto

I get an error message stating "The Microsoft Jet
Database Engine could not find the object "Name.db".
Make sure the object exists and that you spell its name
and the path correctly."
I have copies of DBF and DB files on my local PC. Excel
can open the DBF file with no problem. Also, I can use
conversions plus to convert the DBF to a delimited file
for import.
OS: Windows XP Professional; Office XP (Version 10.0)
There is a note about ISAM drivers, but all I need to do
is convert the files into a table in Access; not to write
to it.

Thanks for your help.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.