MS Access-access denied

[cgalli]

Hello, i'm desperate
in a webform , i set up oledbadaptor (Jet Engine) to an MS Access DB. all works fine (dataconnection, datast, datagrid). the actual data can be previewed and is there. As soon as i start the app, access to the db is denied during the fill(ds) step. error is either the db is blocked by another user or need of permission.

I have tried everything (different location, adding user and password to db etc).

Any suggestions? Many thanks.

 

[kulrom]

Actually, MSAccess file (DB) needs permission by the administrator indeed. If you are the one then note that you should give a permit or ask your admin to make it for you.

Regards

 

[cgalli]

Still not working...

How do I give Access the permission? When I define a user VBNET in acces with all the privileges, the Jet Adapter is unable to open it during devlopment. Do you know of any literature on how to do this? Or even bettercan you tell me how..

Thanks a lot

 

[kulrom]

ASPNET doeasn't have the rights to the database and the folder it resides in. Fix that, and the problem will clear up"
The ASPNET user must have read/write access to the folder containing the
.mdb file. Also check that the file is not read-only (right click -> properties -> uncheck read-only if checked)

Regards