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.

Work-around

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