Files opened in one sub-folder always switch to read-only immediately. I can update the files in notepad, so the o/s doesn't think the file is read-only. Really inconvenient.
Can you provide more steps to reproduce the problem?
There is probably a reason that Toad opens them read-only but without any context it's hard to say. Are you in the middle of debugging? Using Team Coding? Something else?
I don't use team coding nor am i debugging, and it only happens in one folder. Other folders are fine. I've gone through all of the windows remedies for read-only, and outside of toad, the files are fine, but i only get one shot at a file in toad, then nope.
So, are your steps like this then?
- Start Toad and Open Toad's editor (nothing in between)
- Open one of these files
- Try to type, but Editor does not allow changes
- Open a different file
- Try to type, this time Editor allows changes
Is it the folder that's a problem, or the files themselves?
What if you temporarily move one of those files to a different folder? Does it work then?
I connect to a database first, then open a file in that folder. Doesn't matter which database I connect to, files from that folder are immediately read only just in toad. I have copied the files to a brand new folder, same behavior.
Thanks, that's helpful.
I know you said that you can edit these files with notepad, but humor me -
If, in Windows Explorer, you right-click on one that doesn't work to check it's properties (specifically the read-only attribute and security settings), do they look the same as those on a file that does work?
(check permissions on all of the group/user names listed at the top)
Also, are these files on your local hard drive or are they on a OneDrive or some other kind of mapped drive?
I've done all the permission stuff on os. I do not have the same editor menu that you show here, and no read-only toggle option.
How do I clear the toad cached files? Or maybe I should uninstall toad and re-install completely? If I do that, which file do I need to preserve so that I don't lose all my database connections?
Toad does not cache files. I doubt if uninstall/reinstall will solve anything.
Can you post a screen shot of your Editor right-click menu?
Thanks, that helps.
That's not the menu that I meant. Not Toad's main menu. Right-click in the editor text area (where the file contents are) to get the menu that I showed.
Also, I see this is a mapped drive (z:\). I wonder if that has anything to do with it. What if you copy the same file to somewhere on c:\?
OMG I've never seen that menu. That works. Doesn't really answer my question about why it is happening, but at least I can work without copying files into new editor tabs!
Thank you so much.
Grace
I'm glad that helped. I also noticed that in your Editor, the tab with your file says (recovered). Toad does, by default, make backups of your files in the Editor. Then if it crashes and you restart Toad, it will prompt to see if you want to recover any of the backup files. I guess in that sense we do cache files. I misspoke a little before.
I think that recovery has something to do with why the file came up as read-only. Maybe Toad couldn't access your Z drive when it restarted. I'll have to do a little research on that to try to reproduce it.
Also, earlier you asked...
You don't need to re-install to reset Toad to a "like new" state. If you want to do that, and keep your connections, you can follow these steps:
- From the main menu, go to Utilitiies -> Manage User Settings
- Set the options there like this, then click OK. Toad will restart.
It happens even when not in (recovered) state.
Thanks for the settings tip.
Grace