what does error 3011 mean in access?

  • Thread starter Thread starter BH
  • Start date Start date
B

BH

I get this error while attempting to import .DBF files into an Access
database. However, I tried opening the DBF file in Excel and then saving as
a DBF file. I then import this DBF file into the Access db and it works just
fine. Why will it not import the native DBF file?
 
This was the issue:

4b) 3011 - Microsoft jet database engine could not find object 'xyz.dbf'...
Notice the dbf file extension. A dbf file name needs to be in 8.3 DOS name
format. It is quite possible that some machines can open the file with a
longer file name and others it must be in 8.3 DOS name format. Thanks to
Marc L. Allen for this one.

Don't know why I didn't think of that. Thanks.
 
Back
Top