asp security setting

Hi ,

May I know the database can be set at shared drive or not ?

because the asp program will put in my system but the database will key in by HR officer.

so i decided to put the database at shared drive which can be access by my HR officer.

set conn=server.CreateObject (“ADODB.connection”) conn.Open “Provider=Microsoft.Jet.OLEDB.4.0;” & _
“Data Source=J:\HRVacationTimeEmps.mdb;” & _ “Persist Security Info=False”

but i get this error:

Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file ‘J:\HRVacationTimeEmps.mdb’. It is already opened
exclusively by another user, or you need permission to view its data.
/HR/index.asp, line 7

please assists

hoayfern