We are trying to create a link to a FoxPro 2.6 DBF using Access 97. First we used the Access OpenDataBase command where we specified the path and the file type. Then we have tried the Access TransferDatabase command to create a linked table. This fails about 20 percent of the time. We then tried the tabledef.connect to link to the table and this also intermittantly fails. How do I get this to work? Thanks in advance!
