New
#11
Here is what I have done to get Office97 (primarily Access97) to work on Windows7HomePremium and Server2008R2.
Take ownership of C:\windows\System32 and C:\Windows\SysWOW64
Properties - Security - Advanced - Owner - Edit - AdministratorsGroup - Apply - OK - Change permissions - Administrators - Edit - Administrators - ALL - OK - OK
Install Office97 as Custom to C:\Program Files\Microsoft Office NOT C:\Program Files (x86)\Microsoft Office without Outlook (I haven't come up with a solution yet). You will get the CTL3D32.dll error message and maybe some mail error just keep clicking ok. It should say that it was installed successfully.
Copy CTL3D32.DLL and WRKGADM.EXE from C:\Windows\SysWOW64 to C:\Windows\System32
There is no need to overwrite CTL3D32.DLL if it exists.
Before applying Service Pack 2 - sr2bof97.exe, you will need to copy Tahoma fonts from a known good install to C:\Windows\Fonts overwriting if necessary. Apply Service Pack 2.
If you will be using an ACC97 mde, you will need to create an exact folder structure to match the location of any references as they are on the computer that created the mde.
If you need create ODBC connection, be mindful the default ODBC is 64bit and is not 100% compatible with 32bit databases, SQL2005 on Server 2003. I ran into code problems with ADO and the 64bit ODBC. The 32 bit ODBC is located at C:\Windows\SysWOW64\odbcad32.exe
Turn off Data Execution Prevention for msaccess.exe
Start - Control Panel - Advanced system settings - Advanced - Performance - Settings - Data Execution - Navigate to C:\Program Files\Microsoft Office\Office\msaccess.exe
Change the Compatibility for msaccess.exe at C:\Program Files\Microsoft Office\Office to Windows XP (Service Pack 3). Also change the Privilege Level to Run this program as an administrator.
Last edited by MBERG; 28 Dec 2010 at 08:05. Reason: typo