db permissions
-
Hai.. Iam developing a website to download softwares...I have a database in access where I store all the values and paths for the file download... I dont want all the users to write/modify the database thro web.They can only read the db.My db is on the win2000 server.I set the permissions accordingly ie. only admin has full control to db, IUSER has read/execute,and Everyone has only read/execute permissions. But when I logged on the server as admin and I tried to modify/write the db thro web, it didnt allow me and gives error that an 'updatable query must be used'. I referred to some article and found the cause as permissions.The article suggested that I should give full control to the IUSER account.So I changed the permission settings and gave full control to IUSER and inturn everyone. So now any user accessing the web can modify/write the db which I dont want... Am I missing anything here???What is problem??any ideas... thanks a lot..
-
Hai.. Iam developing a website to download softwares...I have a database in access where I store all the values and paths for the file download... I dont want all the users to write/modify the database thro web.They can only read the db.My db is on the win2000 server.I set the permissions accordingly ie. only admin has full control to db, IUSER has read/execute,and Everyone has only read/execute permissions. But when I logged on the server as admin and I tried to modify/write the db thro web, it didnt allow me and gives error that an 'updatable query must be used'. I referred to some article and found the cause as permissions.The article suggested that I should give full control to the IUSER account.So I changed the permission settings and gave full control to IUSER and inturn everyone. So now any user accessing the web can modify/write the db which I dont want... Am I missing anything here???What is problem??any ideas... thanks a lot..
I think one common permissions problem with using Access databases occurs with folder permissions - Access wants to create and manipulate a corresponding .ldb file when an .mdb file is opened. This means that not only do permissions need to be present on the .mdb file itself, but also the .mdb file's containing folder. Try setting permissions on the folder also and see if that helps.