Thanx,

I will check out that path stuff and....


Cetin found it. I had 2 index tags with the same key (custid). It must of become created during development. It did not effect the fpw26 program but vfpoledb could not deal with it. I rebuilt the index and now all is well.

Thanx again,
Neil


>>Hi fellow mm.net users,
>>
>
>Just a comment. It seems to me, that when you create the connection string you specify the path to the DBC or folder for free tables. With this, you shouldn't need to put a path into each select statement? Do you find this is 100% necessary?
>
>BOb