G
Ganesh
I had created an access database. Then I linked it to an excel sheet. So I
created my application with front end as MS-Access and back end as excel.
I am not able to read the data at multiple locations in shared mode.
i.e. I have created a form for reading data from the excel. If I try to open
the form sheet from 2 different computer simultaneously it gives the message :
"Run-time error 3051 :
The Microsoft jet database engine cannot open the file
\\gmuralid-w2k\DSR\.....xls. It is already opened exclusively by another
user, or you need permission to view its data."
I tried giving permissions etc but this error is still coming up.
created my application with front end as MS-Access and back end as excel.
I am not able to read the data at multiple locations in shared mode.
i.e. I have created a form for reading data from the excel. If I try to open
the form sheet from 2 different computer simultaneously it gives the message :
"Run-time error 3051 :
The Microsoft jet database engine cannot open the file
\\gmuralid-w2k\DSR\.....xls. It is already opened exclusively by another
user, or you need permission to view its data."
I tried giving permissions etc but this error is still coming up.