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";