changing the duplicate error message

cherise

New Member
Joined
Nov 21, 2005
Messages
2
Is there a way to change the text of the error message you get when you have a duplicate entry of your primary key? The error message I get is
:eek: "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." Any ideas would be great. Thx.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,275
Cherise

As far as I know there is no way to change these, or any other similar, messages.

What are you actually trying to do?

How are you getting duplicates?
 

cherise

New Member
Joined
Nov 21, 2005
Messages
2
I was duplicating records on purpose. I am getting ready to roll out my database to the people I work with and some aren't the brightest crayons the the box if ya know what I mean and I already know that I am going to get tons of calls asking what they are doing wrong just by the standard message. Basically I just want a message to pop up if they have a duplicate title telling them to change it. Any thoughts?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,275
What are you, or the other users, actually doing that could cause these duplicates?
 

Forum statistics

Threads
1,077,829
Messages
5,336,647
Members
399,094
Latest member
Learner2019

Some videos you may like

This Week's Hot Topics

Top