Claudine, if you have a good sys_layouts3 somewhere then try this: unload the rows for sys_layouts3 from the good db; delete all rows from the sys_layouts3 table in your database with the problem; reload to a new db (or unload & input); input the sys_layouts3 data to the new db.
Good luck, Regards, Alastair. ----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Saturday, March 19, 2005 8:10 PM Subject: [RBG7-L] - Re: Access Violation Messages and Sys_Layouts3tablecorruption > Thanks David. I've got a lot to try. Read Sami's suggestions... I'm going > to try them all :) > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David M. > > Blocker > > Sent: Saturday, March 19, 2005 2:10 PM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - Re: Access Violation Messages and > > Sys_Layouts3tablecorruption > > > > OK, I'm clueless in MA.... > > > > Anyone else got an idea? > > > > David Blocker > > [EMAIL PROTECTED] > > 781-784-1919 > > Fax: 781-784-1860 > > Cell: 339-206-0261 > > ----- Original Message ----- > > From: "Claudine Robbins" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[email protected]> > > Sent: Saturday, March 19, 2005 2:15 PM > > Subject: [RBG7-L] - Re: Access Violation Messages and Sys_Layouts3 > > tablecorruption > > > > > > > Yep, several times... > > > > > > > -----Original Message----- > > > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David M. > > > > Blocker > > > > Sent: Saturday, March 19, 2005 1:14 PM > > > > To: RBG7-L Mailing List > > > > Subject: [RBG7-L] - Re: Access Violation Messages and Sys_Layouts3 > > > > tablecorruption > > > > > > > > Claudine > > > > > > > > Have you tried the old standby, UNLOAD ALL to a file in another > > directory > > > > and then run that file? > > > > > > > > David > > > > > > > > David Blocker > > > > [EMAIL PROTECTED] > > > > 781-784-1919 > > > > Fax: 781-784-1860 > > > > Cell: 339-206-0261 > > > > ----- Original Message ----- > > > > From: "Claudine Robbins" <[EMAIL PROTECTED]> > > > > To: "RBG7-L Mailing List" <[email protected]> > > > > Sent: Saturday, March 19, 2005 1:24 PM > > > > Subject: [RBG7-L] - Access Violation Messages and Sys_Layouts3 table > > > > corruption > > > > > > > > > > > > > Hi all, > > > > > > > > > > We had a small surge at the office yesterday and one of my db's is > > now > > > > > constantly giving off access violation messages which cannot be > > > > resolved. > > > > > > > > > > Upon running RScope 7.5, I find that there is an error in my > > > > sys_layouts3 > > > > > table which cannot automatically be fixed because it contains a note > > > > field. > > > > > This table has two rows, one for an existing 'important' table, the > > > > other > > > > > for a view which I can easily delete and recreate. > > > > > > > > > > What should I do? > > > > > > > > > > Claudine > > > > > > > > > > > > > > > > >
