Run-Time Error 3022

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am getting the following message on the form whenever I try to do anything
to the form (ie. add date, find date,etc.) The message is as follows: "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
redifine the index to permit duplicate entries and try again." On the form I
enter a customer number but then there is another box where the number is
also displayed,it is a drop down box and i can select any record i want from
that box. It will not let me do so. I must have changed something. Can
someone please explain to me what happended or can someone try and help me
correct it? I am so dependent on this database and its broke! Please help
since I am far from an Access guru and do not know what could have happened.
I am also getting a message stating "Update or Cancel Update without Add New
or Edit. WHat does this mean? Please help me!!! Sara
 
Hallo,

If you have an application that worked well before and
now you get a message with that error, it means that
something is wrong with the database.

You should COMPRIME and REPAIR the database.

When you have done so and you have not received an
errormessage, the problem can be solved.

When you get an errormessage, you have to check if there
are no double records. That can be done by running a
query that seeks for that records.

You can also make a new database and import all the
tables of the database with which you have problems.
When that gives an error, it stops at the table with the
error. That is a big help when you know in which table
you have an error.

Don't hesitate to send me a mail if you have further
questions.

Dirk
 
Back
Top