Access 97 with Office 2003 SP2

[MS]

I have a machine running Windows XP Pro SP2 with Access 97 and Office 2003.
Access 97 was running fine until I installed SP2 for Office 2003. Now I am
getting the following message when a user who is a member of the “restricted
users†Users Group tries to open Access 97 – “Microsoft Access was unable to
initialize the Windows Registry. Rerun Microsoft Access or Microsoft Office
Setup to reinstall Microsoft Accessâ€. If I log onto the machine with local
Administrative rights I do not receive this error message and Access 97 opens
up just fine.

I temporarily gave the user local administrative rights on the PC but I
would like to have a true fix for the problem.

Any ideas?

Thanks,
MS

 

[garfield-n-odie]

See
http://groups.google.com/group/microsoft.public.access/browse_frm/thread/943a06e5b67eecee
for a possible solution. Also, you might ask in one of the
Access newsgroups, which is where the Access specialists hang out.

 

[MS]

Thanks for the link - the solution worked

Solution:

In Windows XP, users who (do not have permission to write to
HKey_Local_Machine) can't use MS Access 97 after MS Access 2003 has been used
unless MSAccess.srg is empty. This file controls MS Access 97 .mdb
registration, so on your own PC delete the contents of the file if you don't
want .mdb registration to
switch back to MS Access 97 when you use MS Access 97.


1. Locate the file MSAccess.srg (usually found in C:\Program Files\Microsoft
Office\Office)
2. Copy MSAccess.srg and rename the copy as MSAccess.srg.bak
3. Open MSAccess.srg with notepad and delete the entire contents of the file
4. Save the empty MSAccess.srg file
5. Finished