Hi everybody,
Something happened at a client site which seems to corrupt all their database. (they say they close the NT server while station where still openned but I don't know if this is the cause). Anyway now I'm having this situation:
I try to reindex all tables in the database using code like this one:
OPEN DATABASE CAS EXCL
=ADBOBJECTS(aTableArray,"TABLE")
nTableNbr = ALEN(aTableArray,0)
FOR nTable = 1 TO nTableNbr
USE aTableArray(nTable) EXCLUSIVE
cTableName = aTableArray(nTable)
USE IN aTableArray(nTable)
USE &cTableName EXCLUSIVE
PACK
REINDEX
ENDFOR
For 6 tables I get an error on the line USE .... EXCLUSIVE
The error says :
If I try to open the table in the Data Session window the message is different, it says
If I try to modify the database itself, the tables are not shown in the Database Designer window.
The problem is not locate to one database, it affect three of them, on different tables!
Is there something I can do?
Diane Robitaille eng.