Hello,
I use the Access 2003.
I have a mian form frmM that is based on a query;
I have a sub form frmM_sub based on a table;
The form works fine when it resides on my local drive. Now I move it over on a network drive, when one person use it, works Ok; but no any more person can get into it. When another user try to login it, the error message pop up like below:
"Then Microsoft Jet Database Engine cann't open the file 'qryBase'(which is the frmM's data source). It is already opened exclusively by another user or you need permision to review its data."
Any suggestion? Thanks.
I use the Access 2003.
I have a mian form frmM that is based on a query;
I have a sub form frmM_sub based on a table;
The form works fine when it resides on my local drive. Now I move it over on a network drive, when one person use it, works Ok; but no any more person can get into it. When another user try to login it, the error message pop up like below:
"Then Microsoft Jet Database Engine cann't open the file 'qryBase'(which is the frmM's data source). It is already opened exclusively by another user or you need permision to review its data."
Any suggestion? Thanks.
