Hi guys, help please.  This is a new error I'm getting while trying to

update a database.



Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 



[Microsoft][ODBC Microsoft Access Driver] Cannot update '(expression)';

field not updateable. 



/message/update.asp, line 48 



The Microsoft Knowledge base doesn't really have an answer can anybody help?



Is it an issue with my configuration of access thats causing the problem?



Thanks for you help



Olly.

I had that problem a few weeks ago...  If I remember correctly, you are

opening a recordset with as adOpenStatic with adLockBatchOptimistic...



Then, you try to use the rst.Update instead of rst.UpdateBatch.



If this is not the one (had a few errors a few weeks ago trying to debugging

applications=)), I would suggest verifying that you are not trying to send

NULL to a non-null field (or any other invalid things to that data field).



As I remember though, it should not be an Access problem (since I had the

same error with SQL Server) but rather something to do with the type of ADO

Recordset you are using or the type of data you are trying to send back to

the database.



Maxime Bombardier, MCSD, MCDBA, MCSE+I

Senior Computer Systems Analyst

Sintaks, a Canon U.S.A. division

xxx.xxx.xxxx  (228)



-----Original Message-----

From: Tomkins, Oliver [mailto:Oliver.Tomkins@d...]

Sent: Wednesday, October 25, 2000 4:06 PM

To: ASP Databases

Subject: [asp_databases] updating databases







Hi guys, help please.  This is a new error I'm getting while trying to

update a database.



Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 



[Microsoft][ODBC Microsoft Access Driver] Cannot update '(expression)';

field not updateable. 



/message/update.asp, line 48 



The Microsoft Knowledge base doesn't really have an answer can anybody help?



Is it an issue with my configuration of access thats causing the problem?



Thanks for you help



Olly.

>> The error is on line 6

> How do you know? I didn't post any code

Exactly!



Cheers

Ken



----- Original Message -----

From: "Tomkins, Oliver" <Oliver.Tomkins@d...>

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, October 26, 2000 6:05 AM

Subject: [asp_databases] updating databases





>

> Hi guys, help please.  This is a new error I'm getting while trying to

> update a database.

>

> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

>

> [Microsoft][ODBC Microsoft Access Driver] Cannot update '(expression)';

> field not updateable.

>

> /message/update.asp, line 48

>

> The Microsoft Knowledge base doesn't really have an answer can anybody

help?

>

> Is it an issue with my configuration of access thats causing the problem?

>

> Thanks for you help

>

> Olly.