Hi all!
I use ASP webpage to update records in background access table and get problems.
The SQL statement is just as common as others.
UPDATE table1 SET contact_status='new', contact_date='2009-11-9', company='someone', quote='0' WHERE ID=763
I have omitted certain SQL statements since I use Chinese character in it.
The problem is nothing happened. Then I use above SQL statement to execute just in the view of the background access database and get the following error message:
Cannot update 1 record because the conflict of effectiveness of the rules occurs.
Since the design of the table1 is very simple: all the fields are Text type except contact_date is Date_Time and quota is Currency and ID is Autonumber key.
And I also checked all the field types and the effectiveness of the rules is blank.
I just don't know the reason why this error occurs.
By the way, the table1 once was used to replicate to other tables and I have stopped replication and re-generated the ID since the old one is random number.
Is this the reason?
Any clues would be very appreciated!
I use ASP webpage to update records in background access table and get problems.
The SQL statement is just as common as others.
UPDATE table1 SET contact_status='new', contact_date='2009-11-9', company='someone', quote='0' WHERE ID=763
I have omitted certain SQL statements since I use Chinese character in it.
The problem is nothing happened. Then I use above SQL statement to execute just in the view of the background access database and get the following error message:
Cannot update 1 record because the conflict of effectiveness of the rules occurs.
Since the design of the table1 is very simple: all the fields are Text type except contact_date is Date_Time and quota is Currency and ID is Autonumber key.
And I also checked all the field types and the effectiveness of the rules is blank.
I just don't know the reason why this error occurs.
By the way, the table1 once was used to replicate to other tables and I have stopped replication and re-generated the ID since the old one is random number.
Is this the reason?
Any clues would be very appreciated!