Hello, I have DB located on network, and network cable was cut off
accidently few days ago... now its fixed, but I can't add new records
to the DB with forms...
The error I get is this (when trying to add new record):
"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 contation
duplicate data, remove the index or redefine the index to permit
duplicate entries and try again."
I tried to change the data, first it didn't let me to, then, I removed
relations to table I suspect is causing problems, removed all indexes
on that table, changed "AutoNumber" on one column to "Number", and then
was able to change one last row of data with wierd characters -
replaced them manualy with meaningful data that should be there...
After that, I opened application and was able to insert only one
records, without problems, but then, when tried to insert next new
record - it failed again, with the same message...
Any advice for me what to do, what is the problem here, how to fix it?