I opened the a database with "OPEN DATABASE d:\vfp\vmp\vm.dbc EXCLUSIVE" and then executed "VALIDATE DATABASE". I got the following output:
Validate Database VM:
Rebuilding structural index.... Index rebuilt.
Object #32 (Relation 'Relation 1'): Cannot find associated Index referenced by this object.
What is object #32 ?????
I copied the database and tables to another directory. I opened the copied database with "OPEN DATABASE d:\vmpsample\vm.dbc EXCLUSIVE" and then executed "VALIDATE DATABASE". I got the following output:
Validate Database VM:
Rebuilding structural index.... Index rebuilt.
Object #11 (Table 'generatepk'): Invalid primary key property.
Object #17 (Table 'users'): Invalid primary key property.
Object #24 (Table 'userprefs'): Invalid primary key property.
Object #32 (Relation 'Relation 1'): Cannot find associated Index referenced by this object.
Object #33 (Table 'reportcatalog'): Invalid primary key property.
Object #43 (Table 'lookuptypes'): Invalid primary key property.
Object #52 (Table 'lookups'): Invalid primary key property.
Object #109 (Table 'statesprovinces'): Invalid primary key property.
Object #149 (Table 'parts'): Invalid primary key property.
Object #225 (Table 'invoices'): Invalid primary key property.
Object #262 (Table 'lineitems'): Invalid primary key property.
Why does copying a database to a different directory create all of these problems and what are all of these object numbers ???
Thanks in advance for any help.
Dennis Lindeman