Error 2746 is telling you what you said in 2) - you have not created
any indexes in the database. Create one index and see what happens.
Albert
On 07/10/2010 9:29 AM, Bruce Chitiea wrote:
All:
PROBLEM
When run AUTOCHK, get error message: '-ERROR- Error reading the index
list. (1222)'
SETUP
1) Create a new database;
2) Create and link a handful of core and lookup tables with PKs, FKs
but no non-key indexes or UKeys;
3) Enter data and prove relational integrity ok;
4) Decide I really hate my table/column naming;
5) Delete FKs and rename all tables and all columns ok;
6) Verify PKs for each table ok;
7) Recreate FKs and prove relational integrity ok;
8) Run PACK ok; run RELOAD for clean copy ok;
9) Run AUTOCHK on clean copy, get error message.
10) Run LIST INDEX; advised "There are no user defined indexes (2746)".
Where/how might I look for the problem?
