Alastair, Thanks for all the good info. I have no passwords set yet on this db. What is the DDL file you speak of?
Thanks, Claudine :) > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair > Burr > Sent: Saturday, March 19, 2005 3:24 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Access Violation Messages and > Sys_Layouts3tablecorruption > > Following on from MikeB's comments have you got a permissions problem on > your server? > > It sounds as if your data was, or is now, ok but another system table that > has caused me a problem in the past is sys_passwords. I keep a (secret) > file > now which recreates all passwords in my databases in the rare case of such > problems. (It's mainly used now for when views are amended and the > permissions get removed for some reason.) > > If you can't find any server/OS permissions problem you could try this: > > REVOKE ALL PRIVILEGES FROM ADBB, PUBLIC -- substitute your user name(s) > RENAME OWNER .vResponse TO NONE -- vResponse is the owner password > PACK PASSWORD > RENAME OWNER NONE TO .vResponse > > then you need to re-create your permissions the best way you can! > > The other thing that you could try is copying a good copy of the DDL file > from the last update file. > > Regards, > Alastair. > > > ----- Original Message ----- > From: "Claudine Robbins" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Saturday, March 19, 2005 8:28 PM > Subject: [RBG7-L] - Re: Access Violation Messages and > Sys_Layouts3tablecorruption > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
