This topic is locked
[SOLVED]

 Adding New Record to Access Issue

4/29/2009 1:17:44 PM
ASPRunnerPro General questions
P
pwburton author

I have an access 2007 database.

I have the following settings in the database:

All Macros enabled.

There is 1 table (members) and the key is ID and is set to autonumber.

In the ASPRunnerPro Application:

The field ID is NOT on the Add form.

I get the following message when I try to Add an new Member
Record was NOT added. The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
Any help would be appreciated

Sergey Kornilov admin 4/29/2009

I recommend to post your application to Demo Account (use 'Demo Account' button on the last screen in program). Then open a ticket at http://support.xlinesoft.com sending your Demo Account URL for investigation.

P
pwburton author 5/22/2009

If I upload my database to the ASPRunner demo site I do not have any problems.
I have the following setup:
currently hosting provider (godaddy) has provided a folder named "access_db" with all "require" permissions to read and write to an access database "per godaddy

tech staff".
however here how is the folder structure:
root

----access_db

----output --this is the folder where I upload the asp generated files made by the asprunner.
here is the dbconnection file
<%

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("..\access_db\YPA.mdb") & ";User Id=(Removed);Password=(Removed)"

%>
I can edit and update existing records with NO Problems.
I have the following error when I try to add a NEW record to my access 2003 database:
Error messasge as follows:

Record was NOT added. The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or

relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try

again.
I am using ASPRunner 6.0 Build 766
I have placed this setup pn the ASPRunner Demo Server and I do not have any problems.
Does anyone have any potential suggestions? I am desperate to get this issue resolved.....................
Regards--

Sergey Kornilov admin 5/25/2009

This error message means you trying to insert a value into autonumber field or any other field that doesn't allow manual input.
You still need to contact support showing your application URL.