Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error w/2nd User Accessing Application
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00222136
Message ID:
00222303
Views:
32
Kelly & Jere,
Kelly is absolutely right about the problem most likely being a specific table that cannot be accessed. Check that it isn't opened Exclusively in your VFP, too. I tend to Modify a table and forget to close it before testing the EXE. Instant error.

SET EXCLUSIVE is linked to the datasession, so it must be reset in each form (usually the LOAD() or BEFOREOPENTABLES() methods). Check 'Datasession' in the HELP for a list of SET commands that are linked to the DS.

Unless you wrote your application object (and relatively few of us have done so) there's probably a LOT going on inside it you don't know. You may have a switch, a property or a line of code that sets EXCL ON/OFF.

HTH
Barbara

>To know for sure what record #4 is referring to, you can use your form as a table (USE MyForm.SCX), BROWSE it and see what is in various fields of record #4. However, from your description, more than likely the error refers to a table being in exclusive use. When the second user tries to run the form, they would get a "file access is denied" error. It would show up in the DO FORM command because the error occurs while the data environment is trying to open the table for you (and therefore, the last line of VFP code executed was the DO FORM).
>
>You might try creating a CONFIG.FPW file to distribute with your EXE and add the following line to it:
>
>EXCLUSIVE = OFF
>
>Or, you could add SET EXCLUSIVE OFF as one of the first few lines of your main program (assuming that you have one).
>
>
>>Thanks to all the great help from others in this forum, I've just started multi-user testing of my first VFP application!
>>
>>But.... I'm getting an error when a second user tries to log into my application, and the first user has a form open.
>>
>>I used the WZAPPLICATION class (and wizard) for my application object. The error message I get is:
>>
>> Error loading file -record 4. FasLogin .
>> Loading form or the data environment.
>>
>> Method: CAPPLICATION.DOFORM
>> Line: 41
>>
>> Do h:\fb\fasport.exe
>>
>>CAPPLICATION is my application object. DOFORM is a method built into the WZAPPLICATION class. The error occurs on the following line in DOFORM:
>>
>> DO FORM (lcFileName) NAME this.aForms[this.nFormCount] LINKED NOSHOW
>>
>>What file does the "record 4" apply to? I have checked several of the forms that user #1 has open, and there doesn't appear to be any data environment conflicts.
>>
>>I'm sure I'm missing something obvious, but can't pin it down. Any guidance in further tracking this down would be greatly appreciated.
>>
>>Jere Wilson
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform