Devart Forums

I'm trying to customize the shortcut for one of the predefined snippets that comes with SqlComplete v4.5 beta, and I'm encountering an Access Denied error. I noticed a forum post from 2011 stating to update the permissions on the C:\ProgramData\Devart\dbForge SQL Complete Beta\Snippets\ folder. Although that solution will work, it's not the suggested coding practice. Instead, you should be storing the snippets in the %appdata% folder (which I see you are already using for storing profile info).

More importantly, I chose the "Upgrade" option when running the installer for SqlComplete v4.5 beta. The program successfully installed, but I lost my customized snippets; now I have to remember the few custom snippets that I had added and re-define them. If you had been storing any new or customized snippets in the %appdata% folder, then they likely would not have been lost during the upgrade process (which I noticed started with an "uninstall" step).

I solved the second part of my problem -- I found my customized snippets in folder:
C:\ProgramData\Devart\dbForge SQL Complete\Snippets

The beta version is using folder:
C:\ProgramData\Devart\dbForge SQL Complete Beta\Snippets

I just need to update the permissions and I should be OK. Also, I'll revise what I previously said about "good practices" -- you are at least using the C:\ProgramData folder for storing settings, and that's better than using C:\Program Files (x86)\

It really is too bad that the permissions have to be tweaked by the user post-install. I still do think that %appdata% might be a better location for the customized snippets. You could keep the default snippets in the current location, then look for new/updated snippets in the %appdata% folder.

Since the predefined snippets are the part of the software, we can't put them into each user's %appdata% folder. That's why they are installed into the %programdata% folder.