Trouble writing to an Access Database
I am geting an error when trying to add a new record to my database. I am able to read fromm the tables without any trouble but when i go to add a new record i get
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
here is my code that I am useing to open the table
bjConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Data\Db.mdb;User Id=Admin;" & _
objRS.Open "Booking", objConnOpenDynamic,adLockOptimistic,adCmdTable
the part that is really confusing me is if i want to write to the table without ASP and just use straight VBScritp I am able to write to the table, of course I would rather use ASP to do this the only thing i can think of is working aroiund it by passing all my data to the vbscript page and then writing it and then redirecting off the page but this dose not sound the the most efficent way to handel it. Any one have any ideas?
Thanks for any help