Alastair, I just did that, unfortunately although RScope now reports no data error for sys_layout3, I still have the Access Violation in RBengine.dll to contend with...
Claudine > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair > Burr > Sent: Saturday, March 19, 2005 2:24 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Access Violation Messages and > Sys_Layouts3tablecorruption > > 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 > > > > > > > > > > > > > > > > > > > > > >
