Problem accessing MS Access functions from SAS

Under the current setup, SAS can not see any queries in Centralized_data_front_end.accdb that contain either user defined or built-in MS Access functions. This means that most queries in front end can not be used by Julie in SAS.

In the short run, we can overcome this by using table-generating queries; SAS can access those.

I would like to try the solution suggested at http://www.microsoft.com/en-ca/download/details.aspx?id=13255 and test if SAS can see data if it is used. Julie, can you do this or would you like to work together on this? Ttenbergen 10:25, 2014 March 3 (CST)

Work-around

Julie runs Access queries that update temporary tables, which can then be read by SAS. EG: Created Variables.