Please Help!

[Coder7]

Hi,

I have just started off with ADO, Database programming and I am already facing a problem I cant seem to solve.

Here is the code I have written:


Dim db As New ADODB.Connection
db.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Inetpub\Wwwroot\Tutorial\guestbook.mdb;"
Dim rec As New ADODB.Recordset
rec.Open "Guest", db
rec.AddNew


The problem is that the 'rec.AddNew' statement gives the following error.

"The operation requested by the application is not supported by the provider"

ASP scripts that Insert data to a database dont work either.
But reading from a database works just fine.

[ Please help me solve this problem.I have spent about 3 days breaking my head over it. :-( ]

Thanx. :-)

Abid

[Stevie]

Try something along the lines of

  Set rs = New adodb.Recordset

  rs.CursorType = adOpenKeyset
  rs.LockType = adLockOptimistic
  rs.Open "Guest", db, , , adCmdTable

  rs.AddNew

I may be wrong but I think if you don't specify how to open the recordset it defaults to foward only, which does not allow updates.