When installing a new workstation/location for a client that uses Microsoft Access/Stone Edge for their database, the Access Drivers and Runtimes need to be installed according to this process:



  1. Install 32/64 bit System DSN (whichever one missing) and that should resolve it. Alternate solution below for rare cases only.





Alternate Solution

1. Install Access Database Engine.exe (32bit) (2010) via command prompt using /passive command

2. Install Access Runtime.exe (32bit) (2010)

2. Open RegEdit and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths

3. If there is a value for "mso.dll" delete or rename it to something else. Leave RegEdit open to same path.

4. Install Access Database Engine_X64.exe (64bit) (2010) via command prompt using /passive command

5. Install Access Runtime_X64.exe (64bit) (2010)

6. Go back to RegEdit and if there is a value for "mso.dll" delete or rename it to something else.

7. Profit



Windows may try to add the "mso.dll" value to the registry again after a reboot. To get around this, do the following:


1. Throw the following into a file named access_fix.bat and move it to the client's computer

         reg DELETE HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths /v mso.dll /f

2. Press Windows Key + R, type "shell:startup" without the quotes and hit enter.

3. In the folder that opened, place access_fix.bat file into it and then close it.

4. After each startup, it should delete that registry key value if Windows decided to add it again.