A favoured technique when unusual problems arise is to do an unload/input for the database.
CONNECT <database> SET NULL -0- OUTPUT <database.str> UNLOAD STRUCTURE OUTPUT SCREEN OUTPUT <database.dat> UNLOAD DATA OUTPUT SCREEN Now edit the database.str file. Search for ALTER. Add two lines here: RETURN LABEL Indices and save the file. SET MESSAGES ON SET ERROR MESSAGES ON OUTPUT RELOAD.LOG RUN database.str This will create the structure without indexes and constraints RUN database.dat This will load all the data back into the database OUTPUT SCREEN Again edit the database.str file As the first line GOTO Indices Save the file OUTPUT RELOAD.LOG APPEND RUN Database.str OUTPUT SCREEN This will add back the indices and constraints. RBEDIT RELOAD.LOG Search for the word "ERROR" to see what has gone wrong. --- Marc <[EMAIL PROTECTED]> wrote: > Hi all > > I thought this problem was solved a few months ago but > it is back. I haven't used this db since then so I am not sure > when it came back. > > If I con to the db then enter the owner password > then do Edit all from table I get an error about > a missing sys_layout3 table. But it is there at the > R> when you do list sys%. > > If I put in the owner password first then con to the > db, then edit all from table NO error. > > I have looked for dup MSG and DLL files. > Deleted the CFG file, upgraded the DB, > reloaded..... > > This may not be a big deal since I can work around it > but it makes me nervous that there may be something > else wrong with my db and it will come back and > cause problems one day. > > Any suggestions? > Marc > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
