Hi
I have designed and written an MS Access solution where I thought I would have all users being allowed to access the database at the same time.
However, the second user is getting the following message :
"You do not have exclusive access to the database, if you proceed to make changes, you may not be able to save them later."
The design is as follows :
So I have 5 separate forms.
1) This form adds the core main record in Tbl_Starter_Leaver
2) A form to insert Tbl_RADS data i.e. Tbl_Stater_Leaver v Tbl_RADS
3) A form to insert Tbl_Boarding data i.e. Tbl_Stater_Leaver v Tbl_Boarding_Status
4) A form to insert Tbl_IT_Status data i.e. Tbl_Stater_Leaver v Tbl_IT_Status
5) A form to insert Tbl_SAP data i.e. Tbl_Stater_Leaver v Tbl_SAP
an example of no 2 above follows :
I imagined I would not have problems with multi users entering data but as you can see I am getting error for subsequent users :
"You do not have exclusive access to the database, if you proceed to make changes, you may not be able to save them later."
Any advise would be appreciated, as I am thinking this might be a setting somewhere. I am also about to link an Excel Workbook to it and extract data from it.
Thanks in advance.