Access cannot link to dbf files
Posted on 2009-12-29
I am trying to help a user who has an application written in dBase IV. They use Office 2000. Access sits on the users desktop and the dBase tables are on their server. I am simply trying to link to the dbf files on the server. When I try to link. the "Files of type" only shows mdb and ODBC databases. There is no option in the drop down for dBase files. If I put "*.*" in the file name I can see the dBase files. When I attempt the link I receive an error message that says "Unrecognized database format". I am quite sure this is because there is no option to select dBase IV and therfore Access thinks it is trying to link to an mdb and obviously it is not.
Other systems I have worked on, this option was always there so I am lost as to what to do. I have created an ODBC connection using the driver do Microsoft database.
Any and all help would be greatly appreciated!