Security

Ask something
Discussion Locked

asp security setting

0 helpful
1 reply

by hoayfern

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by dc1

Most likely a ACL problem. Make sure the share has the appropriate rights to allow the application access to it including DCOM settings.

This discussion is closed to new replies.