Kenny, give your users permission to access, and update if you want them to save the layouts, the sys_layouts3 table.
Regards, Alastair. From: Kenny Camp Sent: Monday, May 10, 2010 6:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Error SYS_Layouts3 does not exist - But it does. Could someone tell me what is happening in my live database? I made many changes to my main database this weekend mostly adding a owner name and granting all privileges to public, and granting create to public to allow temp tables. This morning everything was OK for several hours until some compiled version 7.6 users started getting this error message. Error SYS_Layouts3 does not exist. I opened the database with the full version 7.6 and R> list sys_layouts3 it is there with 4 rows. R> browse all from sys_tables3 showed the error and after clicking past the error, it showed the data. I reloaded the database, but the error returned after a while. This system table saves custom layouts that we do not use. Autocheck full shows no errors, and the database appears to be OK. Comparing compute rows and compute count (1) from table gives the same number, so I don't believe it is a broken index. I want to unload and rebuild, but need to wait till after hours if possible. I found layout was set on and so set layout to off and the error does not show up any more in the full version but still appears when calling the browser in the compiled version. Any clues? Kenny ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2865 - Release Date: 05/10/10 07:26:00
