Eric ---
Since the datasession is private, you have to set the environment (including SET EXCLUSIVE OFF, which is probably your problem) for each datasession. Try putting SET EXCLUSIVE OFF in the Load of the Form or in the BeforeOpenTables event of the DataEnvironment.
>I'm working on a set of apps that will share a database in a common location for maintenance and user/security information. The .dbc is opened shared by each app and is provided a path to the data. This works fine if I'm using controls loaded by sql or only do lookups or inserts etc. The problem comes when I try to open a form with a common table in the DE. If one form is open in appA with the userid table in the DE, a similar form in appB using the userid table in the DE will not instanciate. The datasession in both cases is private. Forms used in any of the apps in this group run normally as long as they do not have any of the common .dbc tables in thier DE. I'm not sure how this type of sharing is best implemented.
>
>TIA,
>
>Eric K.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05