transaction handling in multiple running instances

Hi,

I am writing a simple ACcess 95 DB application which will reside on a network server. 5 terminals connected to the server will run the same application (ie there will be 5 running instances of the application). The database has two tables : FamilyDetails and FamilyMemberDetails where FamilyMemberDetails is a dependednt on FamilyDetails.

When I need to insert data for a family, I insert ONE row in FamilyDetails table and MULTIPLE rows in FamilyMemberDetails. Using BeginTrans, CommitTrans and RollBack members of the CDaoWorkspace, I can assure atomicity (database consistency) of the multiple inserts across different tables. But the problem arises when there are multiple instances of the application running.

The question is whether multiple instances of the application use __different, local copies__ of the default workspace or do they all refer to the same default workspace ?
Do I need to explicitly create a workspace and open the same workspace for every instance of the application to achieve transaction control in this kind of multi-user environment ? Obviously in this case I will also need to use the workspace as a parameter while opening/creating the CDaoDatabase object ?

Please HELP URGENTLY.....