Category: SAS

This describes the two approaches.

https://support.sas.com/kb/45/428.html

 

 

 

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