I'm trying to connect Foxpro table ( .dbf) into Access as a link table.
I've done it many times before but this time it doesn't seem to work , and I don't know why.
You will see on the first printscreen of the attachment, When I configure my connection, I choose the directory of the table and I see all of them including dp.dbf and dpadd.dbf. Then when I click OK twice and now I see the screen to actually link my table (2nd printscreen). The tables dp.dbf and dpadd.dbf do not show anymore.
I'm using access 2007 but I tried it with access 2003 and 2000
Foxpro driver used is VFPODBC.msi. All the dbf seems to be the same.
What am I missing