inserting records into MS Access Database

[essdee]

HI all,
The problem that i am facing is that when I try to insert records into MS Access Database from my ASP page.
I have written the following code:

set DB = server.createobject("ADODB.Connection&quot
DB.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.mappath(db1.mdb)"

set rs = server.createobject("ADODB.Recordset&quot
rs.open "select * from orderTab",db,adOpenDynamic,adLockOptimistic

rs.addnew '''this is the line which gives Error

The error is Cannot update as the object is readonly or the locktype does not support Updates..

I have tried to change the cursortype but even then it does not work. The Database is not readonly. I have also checked the permissions on the Virtual Directory, it has read, write and execute permissions.


Please Help

 

[vbkris]

why not use the plain old insert stmt?

sql="insert into table(Columnname1,Columnname2...) values('"&vl1&"','"&vl1&"'....)"

db.execute sql

Known is handfull, Unknown is worldfull

 

[essdee]

I tried using the simple insert statement that you have given, When that is used I get an error message

The query needs an updatable recordset!


So i went for the other method of inserting records

 

[Genimuse]

That's because you're using a recordset. This describes exactly how to do an insert by execution:

http://www.w3schools.com/ado/default.asp