Why am I getting this error when tr

[streborr]

Why am I getting this error when trying to add a new record:

Cannot update the database
Error Description: [Microsoft][ODBC Microsoft Access Driver]Error in row

Error Number: -2147467259

Error Source: Microsoft OLE DB Provider for ODBC Drivers

Thanks,
Rick

 

[Bastien]

Here's a hint. Write the SQl statement to the browser before the update and read it to see that you have the correct variables and the correct order in the SQl statement( also check for quotes, alpha chrs in numeric fields etc). I usually solve my insert prolems here.

Also, next time post some code here. Error messages by themselves don't help much.

hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken