Automating changes to the Registry

[Al Camp]

This isn't an MSAccess question... but a bit of intro information is
needed.
There is a known bug when running Access 2000 and Access2003 on the same
PC.
Access 2000 alters a registry entry whenever it runs, and then when I run
Access 2003, one of the functions it uses fails.

I know how to manually go into RegEdit, find the correct entry, and edit
a "Default" value, so that 2003 will function properly... at least until
2000 runs again. (Aaaarggh!)

I need to find a method to "auto-magically" perform that registry change.
I'm very familiar with .bat files, but I don't know how to address the
registry entry, or how to programatically edit it.

Here's the instructions for manually doing the change...

Select START/RUN and enter RegEdit in the command line, and run it. Using
the Find function, locate the following registry entry.
HKey_Classes_Root\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32

In the right panel of RegEdit right click (Default) and select Modify.
Replace the path and filename in (Default) with the correct path to your
AccWiz.dll file.

Can anyone get me going in the right direction as to how I might be able
to automate this registry change?

Thanks in advance for any assistance,
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Pegasus \(MVP\)]

This isn't an MSAccess question... but a bit of intro information is
needed.
There is a known bug when running Access 2000 and Access2003 on the same
PC.
Access 2000 alters a registry entry whenever it runs, and then when I run
Access 2003, one of the functions it uses fails.

I know how to manually go into RegEdit, find the correct entry, and edit
a "Default" value, so that 2003 will function properly... at least until
2000 runs again. (Aaaarggh!)

I need to find a method to "auto-magically" perform that registry change.
I'm very familiar with .bat files, but I don't know how to address the
registry entry, or how to programatically edit it.

Here's the instructions for manually doing the change...

Select START/RUN and enter RegEdit in the command line, and run it. Using
the Find function, locate the following registry entry.
HKey_Classes_Root\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32

In the right panel of RegEdit right click (Default) and select Modify.
Replace the path and filename in (Default) with the correct path to your
AccWiz.dll file.

Can anyone get me going in the right direction as to how I might be able
to automate this registry change?

Thanks in advance for any assistance,
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Very simple:
1. Make the necessary registry change.
2. Export just the changed value to a file, e.g. c:\xxx.reg
3. Take the file to another machine.
4. Check if that same change is not already there.
5. If it is not, run this command:
regedit /s c:\xxx.reg
6. Check again to ensure that the correct change has now been applied.

 

[Al Camp]

Very simple:
1. Make the necessary registry change.
2. Export just the changed value to a file, e.g. c:\xxx.reg
3. Take the file to another machine.
4. Check if that same change is not already there.
5. If it is not, run this command:
regedit /s c:\xxx.reg
6. Check again to ensure that the correct change has now been applied.

Pegasus,
I studied up on RegEdit command line switches, and using your solution...
I used the /e option to send the correct reg entry to C:\LinkTableFix.reg.
I double click that file and it applies that value to the registry.
I think I'll let windows "prompt" that the process worked. For now, I
need that warm fuzzy feeling that everything went OK. I may later add the
/s call.

Thanks a lot for your help. I'll include this method in my website
document to assist other Access users who have this problem.

Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Al Camp]

Pegasus,
I studied up on RegEdit command line switches, and using your
solution... I used the /e option to send the correct reg entry to
C:\LinkTableFix.reg.
I double click that file and it applies that value to the registry.
I think I'll let windows "prompt" that the process worked. For now, I
need that warm fuzzy feeling that everything went OK. I may later add the
/s call.

Thanks a lot for your help. I'll include this method in my website
document to assist other Access users who have this problem.

Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

PS: I've already added your solution to my web site document. If you would
care to review it, it would be appreciated. But... no obligation on your
part at all... just if you care to.
I would also like give you mention for your help on that my document if that
would be OK. You could use my web site Contact function if you'd like to
send me your particulars.
Thanks,
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Pegasus \(MVP\)]

PS: I've already added your solution to my web site document. If you would
care to review it, it would be appreciated. But... no obligation on your
part at all... just if you care to.
I would also like give you mention for your help on that my document if that
would be OK. You could use my web site Contact function if you'd like to
send me your particulars.
Thanks,
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I appreciate your offer but there is no need to include my
name in your web page. On the other hand you might want
to include a reference www.jsiinc.com. This is Jerold Schulman's
vast and excellent repository for just about any Windows tip you
can think of. Tips No. 0319 and 1087 (among others)
refer specifically to regedit.exe.

 

[Al Camp]

I appreciate your offer but there is no need to include my
name in your web page. On the other hand you might want
to include a reference www.jsiinc.com. This is Jerold Schulman's
vast and excellent repository for just about any Windows tip you
can think of. Tips No. 0319 and 1087 (among others)
refer specifically to regedit.exe.

Pegasus,
Thanks for that info... Since my .doc already covers the two procedures
you referred to, (identical to Jerold's tips) I'll probably just add
Jerold's link to my "Links" page (under construction), rather than within
the doc.
A great Windows resource... I'll write to Jerold and get permission for
the link...
Take care, and thanks agian,
Al Camp