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