Not sure of of this. Bit I did it once, a long time ago.
I think there is a app you can add to the access toolbar bar to open a SAS dataset?
SAS IOM and/or some other SAS office integration?
However if you want to use an ODBC/OLEDB driver, this might work.
I think the latest SAS ODBC/OLEDB driver supports 64 bit MS Access. I think you have to use the 32 bit SAS driver for 64 bit SAS and 64 bit MS access. You will have to create an ODBC dsn(this has always been painful for me).
When you select the driver from MS access with your local system ODBC DSN(not server) , SAS wiill spawn a 'odbcserver' interactive SAS session.
You should be able open MS Access and link to a SAS dataset or a SAS view? When the SAS object is updated you should
see the latest
You can build a sql query inside access that users can click on to display the latest SAS data.
... View more