>Hello;
> I am running office97 with windows NT, using MSAccess I have linked severaltables from FoxPro 3.0 database using VBA but some of the tables do not open in datasheet view. I have changed the arround the order in which the tables are called and it makes a difference, if the "bad tables" are first in the order they do open, but I want to be able to open them in any order.
> The second problem is when I link with FoxPro tables if their name is more than 8 character I can not link them to my Access database.
> Any suggestions, Thanks.Dara
> dhakim@ctgusa.com
Use the VFP ODBC driver. It will solve both of your problems. Altough there's been posts about problems with the latest version of the driver (the one that shipped with VS6.0).