Locking issue after Database Split into FE/BE (Access 2000)

[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.

 

[Golfinray]

A couple of things. First go to tools/options/advanced and make sure you have
sharing set up. Second, the file on your lan that contains the BE must have
read/write/edit/and delete rights for each user and so does the folder it
resides in. Then make sure you have all updates, service packs, and hotfixes
from Microsoft.