A long time ago, reported the "Dictionary is Read Only" error. Generalized fix was to go into AREV and delete DICT.TEMP_. This usually fixed it. Now the problem has resurfaced but with a new wrinkle:

The table is GLOBAL (owner) PAYDATA. I have two environments in which we do development:

SPT and SPTPLUS (this inherits from SPT) which has additional Forms and Stored Procedures and UI components.

I can open PAYDATA from SPT in Table Builder just fine. However, from SPTPLUS, I get the Dictionary is Read Only error. Sure enough at this point, there is a DICT.TEMP_PAYDATA around even though in between the two sessions I logged completely out of SPT before starting SPTPLUS.

Any ideas??

Don:

Not sure what you did - abnormal exit from form or table designer, but it sounds like the temp file exists in SPTPLUS, is not detected by SPT. Solution remains the same, find, delete the table.

Hope this helps.

Bob

Mike ..

That's what I originally thought. I tried the following:

Loaded up AREV and deleted the DICT.TEMP_TABLENAME. For sure not there.

Fired up OI - Account SPTPLUS Userename SPTPLUS. Go to database manager and make sure the table is there. Double-click on the raw table (not the DICT.TABLENAME). Sure enough all the fields are there. Double click on a fieldname to load table builder for it and lo and behold the Read Only error appears. OK, sez I, go back into AREV and ZAP the DICT.TEMP_whatzis. Go into SPT the same way and whoopsie-do, it works perfectly. There's got to be something in the Repository for SPTPLUS that's doing it. In fact, it doesn't matter if I copy SPT.DBT on top of SPTPLUS.DBT. Same old same old. Kinda crappy, no?

Don Miller

C3 Inc.

Mike .. et al.

The SPTPLUS.DBT table contained only a relative path to the data tables (without a drive letter). Instead of the pointer being *F:\OIDATA\SPT it was *\OIDATA\SPT. Interesting that it will attach and use the table properly. It just won't let the tools function on it. Using the editor to modify the .DBT fixed the problem and it hasn't returned.

Don Miller

C3 Inc.

Thanks Don.

Al

View this thread on the forum...