S
Swati
I have a form with a tab control with 2 pages.
Page1:- A subform not related to the parent which is Datasheet form which
displays a list of all records where Date Completed is null (Approximately
50- 60). Double clicking on any record takes the user to page 2 of the tab
Subform (Select * from tblJobs where DateCompleted is null)
Page 2: Shows the fields of the parent form.
Parent form (Select * from tblJob - DataEntry = Yes)
The data entry for the parent is set to Yes.
It was working perfectly fine till I split the database into FE & BE.
Now if the form is open by one user, another user cannot open the form. As
soon as the first user closes the form the 2nd user can view the form.
It works perfectly when the database is not split(.mdb), but I know it is
not the ideal solution for a multiuser environment.
I have also checked db properties to No Locks and record level locking ticked.
I have also tried to change the recorset type to snapshot for the subform
which displays records.
Please help.
Page1:- A subform not related to the parent which is Datasheet form which
displays a list of all records where Date Completed is null (Approximately
50- 60). Double clicking on any record takes the user to page 2 of the tab
Subform (Select * from tblJobs where DateCompleted is null)
Page 2: Shows the fields of the parent form.
Parent form (Select * from tblJob - DataEntry = Yes)
The data entry for the parent is set to Yes.
It was working perfectly fine till I split the database into FE & BE.
Now if the form is open by one user, another user cannot open the form. As
soon as the first user closes the form the 2nd user can view the form.
It works perfectly when the database is not split(.mdb), but I know it is
not the ideal solution for a multiuser environment.
I have also checked db properties to No Locks and record level locking ticked.
I have also tried to change the recorset type to snapshot for the subform
which displays records.
Please help.