800a0cb3 current recordset does not support updating pat white dating
Write "Excel connection opened" ' Load ADO Recordset with Excel Data Set rst Excel = Server. Write "Excel Recordset loaded" ' Open Access Connection Set cnn Access = Server.
Field error '800a0cb3' Current Recordset does not support updating. You should not be using a recordset to modify your data.
This may be a limitation of the provider, or of the selected locktype. thanks We'll need a little more information than that: Database type and version The code you used to generate the error. You should be using SQL DML statements (UPDATE, INSERT and DELETE), preferably encapsulated in stored procedures or saved parameter queries.
If not, you need one Add New, the field loop and an update.
Update Batch Also, is it your intention that you should have a new record for each field?
The small problem is that it returns an error that says: Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. /newbudgetamountprocess.asp, line 32 I would be in your debt if you could help me with the error as I have been at this all day.