SAS access to MS-ACCESS files

I got a new laptop and my SAS lost access to MS-ACCESS files.

The problem was that my old SAS was a 32 bit system.  My new SAS is 64.

Here are the steps to fix:

  • Remove Microsoft Access Database Engine 2010 (English) .  By this I am removing the 32bit related patch.  I found this I think in the add and install program.
  • Install AccessRuntime_x64_en-us.exe (https://www.microsoft.com/en-us/download/details.aspx?id=39358)
  • Use this in SAS syntax ("access" is new; it used to be "pcfiles").

libname john access path="C:\Users\19702\Documents\(07) JSU i3 new\raw\dataset_011.accdb";