Trouble writing to an Access Database

JAdkins · June 24th, 2007, 03:37 PM

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

Error Type:
ADODB.Recordset (0x800A0CB3)
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;" & _
"Password="

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

Jim

misskaos99 · June 26th, 2007, 08:43 AM

can you display a little more coding?

misskaos99 · June 26th, 2007, 08:52 AM

TRY THIS.................

<HTML>
</HTML>
<%
Set bjConn = server.CreateObject("ADODB.Connection")
bjConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Data\Db.mdb;User Id=Admin; Password=pw"
Set objRS = server.CreateObject("ADODB.RecordSet")
SQL = "INSERT into tablename (column,column) VALUES('value','value')"

Set objRS = bjConn.Execute(SQL)
%>

misskaos99 · June 26th, 2007, 08:54 AM

mat41 · June 26th, 2007, 06:03 PM

If you are getting records you do not need to change your connection string. (Go to connectionstrings.com to get the correct one for your needs)

Can get records but can not write to the table sounds like permissions on the folder where your .mdb file is. Has the IUSR got read and write permissions to this location? If not this is required - However, the error is usualy more like "Can not use an updatable query"

Wind is your friend
Matt

JAdkins · June 27th, 2007, 03:05 PM

Actualy I found the problem it wasnt the connection string it was in the setup of my webserver. Thanks again for everyones help this message board has been a great learning tool for me.