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 > > > > > > > > > > > > > > > > > > > > > > > > > > > >
