2
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
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access
Is there any way of modify that key value without Administrator Permission?
Joracosu
Posted 2019-03-26T15:54:31.950
Reputation: 35
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 – 2019-03-26T15:57:04.720
@LPChip the thing is that the key is tinto Local Machine – Joracosu – 2019-03-26T15:59:43.223
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 – 2019-03-26T16:03:56.977
@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 – 2019-03-26T16:11:15.873
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 – 2019-03-26T21:07:42.847