How To Read And Modify Registry Entries Within Access2000

[MarkDicken]

I need to Check and Possibally Modify the following Registry Key:-

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions

Becuase I need to TransferText (Import) files with a .STA extension. The .STA File Extension is not a reconised Text File Format so I need to Lookup (GetSetting) and Update (SetSetting)

As per

http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q239471

I've played with the Syntax and just can not get this to work.

Can anyone help me with the Syntax ???

I have tried the following :-

dim a
a = GetSetting("HKEY_LOCAL_MACHINE", "SOFTWARE\Microsoft\Jet\4.0\Engines\Text", "DisabledExtensions&quot

MsgBox "Entry is " & a & "."

Many Thanks In Advance,

Regards

Mark Dicken
England, UK
Mobile +44 (0)7949 698 380
Email markd@trainingserve.com

 

[jfischer]

Mary, the GetSetting function of VB/VBA goes to a special registry location, as follows:

HKEY_CURRENT_USER\Software\VB and VBA Program Settings\appname\section\key

In order to get to the Registry location you want, you'll need to use the Windows Registry API. Here's a link to a detailed discussion of how to do that.

http://www.mvps.org/access/api/api0015.htm

 

[MarkDicken]

JFischer,

Thanks for the hyperlink, I can read the value and at least be able to pop up a Message Box telling the user that they need to ask their Technical Support Person to Add or Alter a Registry Key.

I was using code from 'Dev Ashish & Terry Kreft' already but wanted to Write/Update the Registry aswell as read.

Many Thanks

Regards

Mark Dicken
England, UK
Mobile +44 (0)7949 698 380
Email markd@trainingserve.com