Here's a little additional info, in case it helps. And man, do I need help...

One user is in my Orders form adding new orders and another is in my Invoice form billing older orders. The person who is entering new orders is doing nothing with the orders that the person doing the invoicing is invoicing.

The person who is posting invoices is getting the following error message:

Program : PROCEDURE FORM1.PAGEFRAME1.PAGE4.CMDPRINT.CLICK I:\PONTOTOC\INVOICES.SCT
Line : 365
Error # : 109
Message : Record is in use by another user.

Here is the code that's generating the error in my Invoicing form. I'm scanning through my order header file (ORD_HEAD) to see if there are any remaining detail lines in ORD_LINE. If there aren't, I'm deleted the record in ORD_HEAD:

sele ord_head
go top
scan
if !indexseek(ord_head.order_no,.f.,"ord_line","order_no")
dele
endi
endscan

Line #365 (the line of code that's causing the error) is DELE.

The table ORD_HEAD is opened in the Data Environment of my Invoices form with the Exclusive property set to .f.. The table ORD_HEAD is also opened in the Data Environment of my Orders form with the Exclusive property set to .f..

What could be causing this error? The person who's entering orders is not entering the order that the person who's posting invoices is deleting through the posting process, so the record SHOULDN'T be "in use" by anyone else.

Thanks very much!

>>Hi all,
>>
>>In the new system I've installed, our users are getting lots of "Record in use by another" or "File in use by another" error messages. These have been occuring when one person is entering orders and antoher is selecting orders to be invoiced (both using the ORDERS table, obviously).
>>
>>I'm a rookie VFP guy, so please forgive what is probably a very basic question, but what do I need to do to my database/tables/forms/etc. to allow shared access?
>>
>>Thanks!
>>
>>John
>
>

Set exclusive off

>Or even better, add EXLUSIVE=OFF to config.fpw