mcrmg
asked on
permissions to an user except writing to a database
Hi,
I have an ASP and Access DB. I was wondering if this is doable? Thanks.
https://www.experts-exchange.com/questions/20937262/Assigning-permissions.html#10714611
I have an ASP and Access DB. I was wondering if this is doable? Thanks.
https://www.experts-exchange.com/questions/20937262/Assigning-permissions.html#10714611
ASKER
The reason I asked is because if I did not check "modify" as permission, the *.ldb files keep showing up (I use Access as db),
if I check modify, *.ldb files disappear when users are done with db
if I check modify, *.ldb files disappear when users are done with db
The ldb file is just a locking file which I guess is just being used to lock the database to prevent modification in the first instance but in the second disappears once the an update is complete. That is a guess though (although it has just given me a clue to another problem that I have seen!)
Steve
Steve
ASKER
You are 100% correct. The strange thing is it wont go away if I uncheck "modify"
>The strange thing is it wont go away
Ever or does it disappear if the application closes. (Edit the global.asa and save it to force the application closed).
Steve
Ever or does it disappear if the application closes. (Edit the global.asa and save it to force the application closed).
Steve
ASKER
Could you provide ex? Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry if this is a dumb question.....what should be the value of Application?
It doesn't matter the server watches the global.asa file for changes if it changes it closes all he sessions and the application.
ASKER
Okay, so all I do is paste this in asa?? Thanks
<SCRIPT LANGUAGE="VBSCRIPT" RUNAT=SERVER>
SUB Application_OnStart
Application("test")="test"
END SUB
</SCRIPT>
<SCRIPT LANGUAGE="VBSCRIPT" RUNAT=SERVER>
SUB Application_OnStart
Application("test")="test"
END SUB
</SCRIPT>
yes in a file called global.asa in the root of your web server. When you want to force the application to shut again edit it and save it agains.
Steve
Steve
ASKER
Can you gice a ex?? (I do not quite get it...sorry :( )
I have given you an example above
ASKER
So, Application("test")="test" , both must have the same values?? and I do not have to do anthing in onend?? Thanks
<SCRIPT LANGUAGE="VBSCRIPT" RUNAT=SERVER>
SUB Application_OnStart
Application("test")="test"
END SUB
</SCRIPT>
<SCRIPT LANGUAGE="VBSCRIPT" RUNAT=SERVER>
SUB Application_OnStart
Application("test")="test"
END SUB
</SCRIPT>
It doesn't matter all it is about is change the global.asa file so that the server restarts the application and this way you might see the ldb file close. Just try it
Steve