>>>>>I am linking a free table to my input table in a view via a uniquely defined field. The link occurs in generating the view and I have no problem while running my program in VFP, but when I create my executable, it tells me it cannot find the table and asks if I want to locate it. I can then locate my table and my executable runs fine. But I don't want the user to have to go through that step.
>>>>>
>>>>>Any help?
>>>>>
>>>>>Barbara Smith
>>>>
>>>>Is your free table in VFP path?
>>>Yes, it is.
>>
>>Are you in a form when you are doing this, and if so, are you useing a Private Data Session?
>>
>>Ed
>Yes,I am displaying the result of the view on a grid in a form. But I don't know what a Private Data Session is so I'm probably not. The form is supposed to be used by multiple users showing their own unique (and exclusive) individual data. Do I need a private data session and, if so, how do I do it?
>
>Barbara

Barbara:

You might try a private data session. In your form properties, change data session to 2 -Private Data Session. Add your free tables to this data session in the Load Method useing the usual method ie:
SELECT 0
USE table ALIAS Table

If you make any calls to any methods outside of your form you are going to need to pass the DataSessionId property of the form to the method. At the top of this method type the command:

LPARAMETERS lnDataSession
SET DATASESSION TO lnDataSession

This is not necessary if you are calling a method in the form. If you do not do this, any updates to tables will reflect int he default data session and not the private one.

Hope this works.

Ed