Can't open database - duplicate values in table?

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

First of all, this is a great community. I've been reading
some posts around here and it seems like a wonderful place.

My knowledge of Access is limited, but I have a question.
There is a exe program that was not programmed by me. I am
trying to open up an .MDB file in it, and I am getting an
error that doesnt seem to make sense to me. The error 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
redefine the index to permit duplicate entries and try again."

I searched the entire database for duplicates and no
primary key has a dupe. I also allowed duplicates for all
primary keys and it still will not open the database.

This program is very important to me and I need it to be
able to open the database, as it includes 10 years of
statistical research. The program (which is a 3rd party
program) allows me to create all kinds of queries and
reports that are invaluable to me.

I read a few posts that said this error could be due to
some autonumber fields. I do not believe the .MDB file
contains ANY such fields.

Any help would be greatly appreciated. You can email me at
(e-mail address removed) or find me on AIM as screename Qrashnburn.

The program is located here:
http://jcato.net/downloads/index.html (History v5)

The database is located here:
www.cicnys.org/hblhist.zip

Thanks in advance,

Q
 
Matthew,

I don't think you're going to like this answer, and after you said such nice
things about the newsgroup, too...

If the program is an .exe, it's not written in Access. VB maybe, or some
other programming language. If you can open the database in Access, which
apparently you can, there's nothing wrong with it, so the problem is in the
program itself, and without source code, nobody here is going to be able to
help you, I'm afraid.

Your best bet would be to go to whoever sold you the program and get their
help. Failing that, make a copy of your database. MAKE A COPY -- you don't
want to take a chance on losing all that data! Then try doing a Compact and
Repair. Or re-installing the program. Or moving the database somewhere
that it can't find it, and see if it will re-create it. If it does, you
might be able to import the old data into the new mdb. Or try deleting all
the records (KEEP A COPY!) and then importing them a few at a time, maybe
there's one that's breaking it.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Back
Top