Re: Jet.OLEDB and Access 2003

It does have a primary key. As for the permission, it's
read/write/execute/delete. Keep in mind that everything has been working. The
only thing that changed is that now I'm running under Access 2003 and XP, as
opposed to Access 2000 and Win2K.

"Douglas J. Steele" wrote:

> 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: System.Security.SecurityException was unhandled
    ... The exception gave you the CLSID. ... the first thing to check might be whether the COM server ... assembly actually has the permission in question. ... When I execute the application I received and error message. ...
    (microsoft.public.dotnet.security)
  • Re: System.Security.SecurityException was unhandled
    ... assembly actually has the permission in question. ... Try and find the sorce of the security permission error, ... setting was done on both versions 1.1 and 2.0 .NET framework. ... When I execute the application I received and error message. ...
    (microsoft.public.dotnet.security)
  • Re: System.Security.SecurityException was unhandled
    ... Is it a must that I need to register the COM server to the machine using ... CAS permissions on the client machine, and the COM issue is a new problem. ... assembly actually has the permission in question. ... When I execute the application I received and error message. ...
    (microsoft.public.dotnet.security)
  • Re: System.Security.SecurityException was unhandled
    ... I was using Oracle so was getting an Oracle permission problem. ... setting was done on both versions 1.1 and 2.0 .NET framework. ... On the server or the client? ... When I execute the application I received and error message. ...
    (microsoft.public.dotnet.security)
  • Re: SQL CLR Sproc isnt running right
    ... did you grant rights using the SQL Server 2005 Surface Area Config tool? ... and I got a permissions error back saying DBO doesn't have permission to insert records into the table... ... but the assemblie's stored procedures do all have execute permissions set for the role that the executing user is in... ... "William Vaughn" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)