Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicate Error - Which index

Status
Not open for further replies.
numbat

numbat

Technical User
Jul 23, 2002
6
CR
Does any one know how to determine which index is causing a dupicate value error (3022) in a table with multiple, no duplicate indexes.

Thanks
 
Sort by date Sort by votes
I have always just removed one, run the query, see if the error goes away, and return the index. Do this for each index in the table.

Crude but it works.

[COLOR=006633]Bob Scriver[/color]
MIState1.gif
[COLOR=white 006633]MSU Spartan[/color]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Question
TransferSpreadsheet 3125 Error
Replies
5
Views
1K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Find error in currency feild 2
Replies
8
Views
1K
Andrzejek
Andrzejek
Kim296
  • Locked
  • Question
Sending Gmail using vba Send error
Replies
6
Views
1K
strongm
strongm
VicM
  • Locked
  • Question
Error when using Immediate window-recent happening 2
Replies
4
Views
686
VicM
VicM
Fino
  • Locked
  • Question
Compile error on Office 365 desktop in 64 bit
Replies
7
Views
739
Fino
Fino

Part and Inventory Search

Sponsor

Back
Top