Error message Access2000 aspdbEP Eval

[Col]

I'm getting the following error when updating or deleting records in Access 2000db. Error: Records Affected > 1, Transaction rolled back. I've tried setting fields to "duplicates ok" also "indexed no" without success. AspdbEP eval.Any help would be appreciated.
Thanks in advance. Col

[John]

Hi Col,

The problem is most likely due to the fact that the BookMarkFlds in your
dbEditParams is not unique. Usually people set this to an Autonumber field
(in Access) or other KEY field. For example, let's say you set it to a
LastName field. Now say you edited "Smith" and changed "John" to "Jon".
ASP-db would do an UPDATE Tablename SET ... WHERE LastName='Smith'
This would potentially cause a dozen "Smith" records to get changed. Since
you normally wouldn't want to do this, ASP-db will catch this "multiple
records changed" error and roll back the transaction. One solution would
be to make the bookmark fields LastName+FirstName. If that's not unique,
maybe the phone number or Social Sec No would be. Whatever it takes to make
the update unique is what you need to specify for the bookmark fields.

Hope this helps. Thanks,
John


------------
Col at 1/24/00 4:16:50 AM

I'm getting the following error when updating or deleting records in Access 2000db. Error: Records Affected > 1, Transaction rolled back. I've tried setting fields to "duplicates ok" also "indexed no" without success. AspdbEP eval.Any help would be appreciated.
Thanks in advance. Col