Tony's Microsoft Access Blog

This was true for Access 2007!

You'd think M$ would get their act together for long file names...

I changed the name of my DBF file and Access inorted it with no problem.

Solution was too easy :-)

Thanks if works :-)

Spot on. 8 character filename limit. Thanks!

Thank you very much for the information.  This has helped quite a bit!  Cheers!

Wow, that did the trick, i never would have thought of that- thanks!!! It just seems so archaic. Maybe I should chisel my code on stone tablets while I'm at it.

But why this doen't solve my problem.

Had a similar issue with a file that had name.2ndname.txt and Access will not find it.  For whatever reason, it does not recognize or can not find a file that has two dots.  Thanks for the comment, though.  It helped send me looking in a differennt direction.

Hello.. My 3011 error specifies engine not finding the database object.

The .mdb file was pulled from backup tape. File should have been closed when the tape ran through, but maybe not.

Need to recover the backup to get deleted records that happened the following day. So there was no real corruption event.

Any ideas. (PS.. where do I go to look for .dbf file?)

I've got something weird going on.  I am trying to open a database named "MMD Access", but the object the engine is unable to find it names as "databases" (this error shows when I try to open the database).  Now  *that* is more than 8 characters, but I don't know where this object is to fix/rename it.  HALP!

Thanks,

Naomi

>^,,^<

Note that Access 2003 supported long file names until SP 3. Once SP 3 was released it, apparently, reverted to an old default behavior.

Too bad the error message wasn't as useful as this post! Renaming the dbf file worked perfectly!

Thanks! Changing the name solved my problem.

I get this message trying to use/query a (large) linked List in SharePoint; all the other lists (smaller) open just fine.

Is there a registry adjustment required?

Do they have a patch of some sort to allow for more than 8 character filenames?

You are AWESOME!  Thanks so much!

Spot on! Just what I needed.

This solved my problem, however sometimes this works on other machines but not mine.  Why is this?

Tony,

I can't thank you enough... This tip helped my company meet a deadline of a 1M$+ contract. AND it makes me look good....

Thank you, God and Google... :)

Cannot find DBF file in a given folder

This happened in a SQL Server 2008 R2 SSIS package as well. I can access FoxPro tables fine from my own machine but when I store the package on the Server and execute from a job it could find the tables. I renamed one to 8.3 format and it was able to access after turning the ValidateExternalMetadata off.

Thanks for this post!