Drilldown on Database HELP PLEASE I THINK I AM GONNA CRY

[RGoldthorpe]

Can somebody explain what this means please heartacttack time for me I think due to be rolled out and now coming up with this error also says something about in valid indexes but have removed all of them

Exact error No drilldown information is available for the data1 database. The database may be invalid

Please reply

Love

Rach

 

[weedz]

Try the following:

make a bacup of all your database related files, tables etc.

Than try to open the database,
like:

OPEN DATABASE MyDataBAse

If it succeedss, try the following:

VALIDATE DATABASE RECOVER

This might help you recover the database.

Good luck !!

HTH,

Weedz (Wietze Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

CrownBase source code can be downloaded !!

 

[RGoldthorpe]

Hi

Tryed Validate recover but then it comes up with Index does not match the table. Delete the index file and re-create index trouble is can't get in to data1

Please still help

Rach

 

[weedz]

If you can open the data base, I take it, you can also open the tables.

Try to open the specific table and issue:

REINDEX

If you do not know which table it is, you will have to open all tables with indexes and issue:

REINDEX on every table.

HTH,

Weedz (Wietze Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

CrownBase source code can be downloaded !!

 

[rclarke]

I can open database but not tables
it come up with indexing error as above

AArrrggggggg!!!!!

Apriciating all help

 

[weedz]

Open your database exclusively and issue a VALIDATE DATABASE.

F.i.

OPEN DATA myDBC EXCLUSIVE

SET DATABASE TO myDBC

VALIDATE DATABASE

it will now rebuild the structural indexes.

HTH,
Weedz (Wietze Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

CrownBase source code can be downloaded !!

 

[RGoldthorpe]

Thanks Weedz

it turned out to be a corrupt tempory file. I recorvered the whole data file from a backup and then did the validation and it now works.

What a nightmare.

Thanks for your help

Rach