>>>I'm facing the following rather strange problem. I have a form with agrid and set of command buttons for entering data for a many to manyrelationship. When the forms data session is set to default data sessionit works fine but if I set it to private data session after sometime I get the following error - Record in Use by another User!This is really driving me nuts.Thanks for all the helpSonali>Hi Sonali,>As Steven pointed out some sets scope to the current data session. "set exclusive" is one of them. You may need to set it for private data session too.>CetinI don't want to set exclusive on as I am allowing the user to openup other forms and this would then restrict the user's options. Furtherthe long term plans are for a multiuser systemThanksSonali

Cetin wasn't suggesting to SET EXCLUSIVE ON. Exclusive is one of the seting that reverts to the default in a private datasession. You need to SET EXCLUSIVE OFF in the Load method of your form or form class. You want to look at all the SET commands that scope to a private datasession. You may find other surprises there. Mine was SET CENTURY. I knew I had it set on in my startup code, but all my date fields were only showing 2 digit years. It drove me crazy until I discovered the private datasession reverted to the default of off. I added code to set the environment I wanted in the Load method of my base form class to fix the problem. Again see the help topic for SET DATASESSION for a list of these SET commands.