This topic is locked

add record problem?

2/24/2006 12:21:33 PM
ASPRunnerPro General questions
O
obscura2k author

I get the following error message when adding a record:

Microsoft OLE DB Provider for ODBC Drivers error '80040e2f'
[Microsoft][ODBC Microsoft Access Driver]Error in row
/lolzor/_Players_add.asp, line 904


and line 904 of Players_add.asp reads:

rs.Update


Anyone?
Thanks <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2508&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />

Sergey Kornilov admin 2/24/2006

Need to see your ASP files to find what's wrong.
Common reasons are:

  • some required fields are not filled
  • some values are incosistent with field type
  • incorrect value in foreign key field that refers to another table
  • an attempt to assign value to autonumber field
    If this doesn't help zip and send your ASP files, sample database and project files to support@xlinesoft.com.