Jet.OLEDB and Access 2003

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: How to determinate the vesion of Sql2005
    ... > The user of my asp.net program use Sql2005 or Sql2005 express as database, ... > If I use Sql2005 express, the Data Source in connection string will be ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • connection string
    ... Can anyone se whats wrong with my connection string? ... It works until I secured my database and changed the string to include user ... Prev by Date: ...
    (comp.lang.basic.visual.misc)
  • Re: How to execute sql command just like "Drop DATABASE " and "Res
    ... only in my connection string I don't of course not ... tell to use a database. ... Cor ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to connect to
    ... > I am in need to work with VB with database as ... > FielMaker 6.0. ... > to make a connection string for connecting Vb to Filemaker6.0 ... Prev by Date: ...
    (microsoft.public.vb.general.discussion)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... database without knowing anything beforehand except the driver name. ... need a connection string and different data sources use different connection ... ODBC, ADO, and VB Script. ...
    (microsoft.public.dotnet.framework.adonet)