I've been using Lotus Approach and am trying to migrate to Access 2007. My primary database in Approach has two dbf tables. In Access I went to external data, and with no effort linked to one of them (I want links so I can use both Access and Approach). When I try to do the exact same thing with the other dbf, I get a message that says "the Microsoft Office Access database engine could not find the object CDCompTitle.dbf" and to make sure it exists and is spelled correctly. Since I clicked the browse button to get there it IS there and IS spelled correctly.
I've been searching online for a few days with no results. Several responses to others with this problem said the dbf file is corrupted. I took my dbf (which works with no problem in Approach) and exported to a new file and got the same results on the new file. Other suggestions were about the Jet Engine, updates, etc. but I have SP 2 for Office 2007 and I think that's the latest.
Any suggestions?