Re: Jet.OLEDB and Access 2003

Do you have a primary key defined on the table? I believe it's necessary for
the scenario you're describing.

Also, what permissions does the security context under which ASP is running
(usually IUSR_<machine name>) on the folder where the MDB file exists? It
requires at least Read, Write, eXecute and Delete.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Radon" <Radon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A33CA8DD-007A-428D-AC05-D79A0851702B@xxxxxxxxxxxxxxxx
> I'm running an old ASP program that worked just fine w/ Access 2000
> (Win2K).
> Now, when I run it against an Access 2003 db (XP) I get the following:
> Cannot
> update. Database or object is read-only. Note that the program is able
> to
> read the db.
>
> My connection string is as follows: Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\myLocalSite.mdb;Persist Security Info=False
>
> The program seems to break while executing the following:
> Set objRS = Server.CreateObject("ADODB.RecordSet")
> objRS.Open strSQLStatement, strConnect, adOpenStatic, adLockPessimistic,
> adCmdText
>
> Session("visits") = objRS("VisitorNumber") + 1
> objRS("VisitorNumber") = Session("visits")
> objRS.Update
> objRS.Close
>
> I'd appreciate if someone could help me out.
> Thanks!
>


.

Relevant Pages

  • Re: Impersonating a domain user for debugging purposes
    ... > As a sysadmin role member, you can execute a SETUSER command to use ... > You can revert back to your own security context by running SETUSER with no ... > test it with my permissions, ... > when UserA attempts to execute SProcA, it fails for them, because they do ...
    (microsoft.public.sqlserver.security)
  • Re: Impersonating a domain user for debugging purposes
    ... you can execute a SETUSER command to use ... You can revert back to your own security context by running SETUSER with no ... test it with my permissions, ...
    (microsoft.public.sqlserver.security)
  • Re: Run an SP as another user
    ... To the best of my knowledge, the security context of a stored procedure is ... > doesn't have permissions to execute some of the statements in it. ...
    (microsoft.public.sqlserver.security)
  • Solaris 10 autofs directory permissions - Solution
    ... the fact that my map file has 755 permissions not 644. ... If the execute permission is set, it becomes an executable map which is ... map is expected to return the content of an automounter map ...
    (SunManagers)
  • Re: Rights to execute jobs?
    ... Does anyone know if the rules surrounding stored procedure permissions apply ... Does this apply to a proc calling sp_start_job so that I ... raise the alert, so it could be anyone on the server. ... is that a group needs to not be an admin but still be able to execute ...
    (microsoft.public.sqlserver.security)