Data Access Errors continue!

Jamie Harwood jamie.harwood@caddock.com
Tue, 19 Feb 2002 13:49:26 -0800


Hi all - I got some good suggestions last week on my problem trying to
standardize my part numbers. I'm creating subfiles for all of my detail
datasets and master set, doing my conversions, sorting to remove duplicates,
cleaned out the datasets using the purge option in DBGeneral (4.4), even
re-indexed my keys with Omnidex, but when I use QTP to start reloading data,
I still get a data access error on my master set (the first set I am
reloading):

----------------------------------------------------------------------------
---
Data access error.
[1]
   File:  IM
     Linkitem:  PART-ID

Action Taken: Run terminated.
----------------------------------------------------------------------------
---
Attempt to add a duplicate value when UNIQUE KEY/INDEX was specified.
   File:  IM
     Linkitem:  PART-ID
----------------------------------------------------------------------------
---
Yikes! what now???

__________________________________________________
Jamie Harwood
 IS Manager
 Caddock Electronics, Inc
 (909) 788-1700 x2244
 High Performance Film Resistors
 jamie.harwood@caddock.com
 http://www.caddock.com