I need to do an ADO query from Excel using ADODB.Connection with several types of data. The problem is that in some cases some of the result's recordset have the values empty or numerical. As this connection with ADO automatically detects the type of the fields using only the first 8 recordsets, the query sometimes fails.

Searching on stackoverflow I found one solución, but it implies to edit the register but I am not administrator user of the computer.

Se next link: https://stackoverflow.com/a/46174530/7787606


Is there any way of modify that key value without Administrator Permission?

  • You do not need permissions if you want to write to Current User. The other keys do require administrative privileges. If you know the exact key, you can open regedit as Administrator, navigate to that key, right-click it, select permissions, and give yourself write permissions.
    – LPChip
    Mar 26, 2019 at 15:57
  • @LPChip the thing is that the key is tinto Local Machine
    – Joracosu
    Mar 26, 2019 at 15:59
  • And this is for doing it on the office's computer, so I don't think they would give me access to restricted keys
    – Joracosu
    Mar 26, 2019 at 16:03
  • @Joracosu - If the key is in the HKLM root, then the only way to have write permissions is for you to have Administrator permissions
    – Ramhound
    Mar 26, 2019 at 16:11
  • Ask the IT department to grand you rights to just that sub key. It is really easy to do and will allow you to do your work without actually requiring to be an Administrator.
    – LPChip
    Mar 26, 2019 at 21:07

1 Answer 1



If you are trying to write to any registry keys besides HKEY CURRENT USER you must have local administrator rights.

There is no way around this.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.