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
