How do I link FoxPro 2.6 Tables to my Access 2000 Database?

Used ODBC.

Some FoxPro Tables (.DBF) open up fine and others do not.

Ones that do not open, I get the following error message:

"Could not execute query; could not find linked table.

[Microsoft][ODBC Visual FoxPro Driver]File 'Blah' does not exist. (#173)"

Link file the same way in another Access 2000 database and works fine. Problem very speradic.

Also Date fields acting funny, some have dates, blank ones show 12:00:00 AM

All FoxPro 2.6 tables link fine in Access 97, but want to upgrade to at least 2000.

Any responses will be greatly appreciated.