I am submitting data from a form (using Frontpage 2000)to a database in Access 2000.

The ODBC connection is working as far as I know.

The table that is updated has a primary key (of a text data type using the format - AR-118, AR-119). Also in the database is a module that automatically increments the primary key, whenever a new record is entered. The module used is copied from the microsoft's knowledgebase and can be found at http://support.microsoft.com/support/kb/articles/Q209/8/30.ASP?LN=EN-US&SD=gn&FR=0&qry=how%20do%20you%20increment%20a%20numeric%20string&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000
. In order for this module to work a record should be inputted to start the primary key such as AR-110.

Every time a user submits data from the form, it should be submitted to the table. It should also be given a primary key such AR-111. When a second user submits data to the same table, the primary key should automatically be incremented by 1 such as AR-112.

The problem is that when data is submitted to database I am given the following error message:
Cannot update the database
Error Description: [Microsoft][ODBC Microsoft Access Driver]Error in row

Error Number: -2147217873

Error Source: Microsoft OLE DB Provider for ODBC Drivers.

Note: The pages used and the database are hosted by a hosting company. If I need to make changes of any kind I need to contact them.

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!