How to modify this msaccess database?

Posted on 2008-11-03
Last Modified: 2012-05-05
Hi folks,

I'm using an Ms Access database which should be modfied but Im not sure as to what I shoud modify. When adding data to the table and trying to safe I get an EOleException stating that the entered data causes duplicate values for either the index, primary key or relation. Furthermore it suggests to alter the fields which are in conflict or redefine the index. Now the program shouldnt complain when two fields are the same, for instance city will often be the same amongst others.

Can anyone take a look and see what is wrong?


Question by:PeterdeB
    LVL 28

    Accepted Solution

    the only index which doesn't allow duplicates is Nummer (btw, I do't know the language you're using and I'm too lazy to figure it out and then use a translator :P)
    so the problem is with that field. either set the idnexed proeprty to "Yes (duplicates ok), or make sure you don't add duplicates :)

    PS: I'm turning the PC off (midnight here). so if you still need help and nobody gets in this, you'll get it tomorrow ;)

    Author Comment

    Solved > It was the primary key as well so I changed that and changed the index now Im happy thanks ;)
    LVL 28

    Expert Comment

    you're welcome :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
    Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now