My ADO.Connecton remains ReadOnly in ASP. I am also changing the Connection.Mode to ReadWrite?

Question

I am developing an ASP page for web site. I am using ADO to connect to my Access database. When I open ADO.Connection it always opens in ReadOnly mode and doesn't update the tables and gives message "OPERATION MUST USE UPDATEABLE QUERY". I am using ConnectionMode=3 or 16 but when I see the ConnectionMode in properties system shows that ConnectionMmode=1. If I use the same ADO.Connection command in Visual Basic it works and update the table but in ASP it doesn't work. I am using IIS (Internet Information Server 5.1). and my database is Microsoft Access. Please help me out.

My mdb file is not read only and the same code is working in Visual basic. I have a table with the name "Staff" and a field in it with the name FullName. My Query is "Update Staff set FullName='Qadeer'". It works in VB but doesn't in ASP. I have copied all my ASP project into another computer with same IIS version and same MS Access version and it works fine but in my computer the connection object opens the database in readonly mode

Dear BOB:
I am writing the same code as mentioned by you but still its not working it establishes the connection in ReadOnly mode

Dim strSQL
strSQL = "select * from Table WHERE ID > 10"
Dim ObjConn, ObjRec
Set ObjConn = Server.CreateObject("ADODB.Con...
Set ObjRec = Server.CreateObject("ADODB.Rec...
ObjConn.Open [some_connection_string]
ObjRec.Open strSQL, ObjConn, adOpenKeyset, adCmdText

Answer 1

There are a few things you have to do to update a database in Access:

1, Don't query an Access query. Query the tables directly with SQL language calls, i.e.

Dim strSQL
strSQL = "select * from Table WHERE ID > 10"
Dim ObjConn, ObjRec
Set ObjConn = Server.CreateObject("ADODB.Connection")
Set ObjRec = Server.CreateObject("ADODB.Recordset")
ObjConn.Open [some_connection_string]
ObjRec.Open strSQL, ObjConn, adOpenKeyset, adCmdText

...also, make sure you are opening the recordset with a locktype like adOpenKeyset that permits updating....

Answer 2

Is your database (.mdb file) set to read-only?

What is your query?

[EDIT]
Does your IIS user have access to the directory that the mdb file is in? Check the permissions in the IUSR_YourAdmin user account. Don't worry about setting a ConnectionMode value either.