Following Libname statement works in SAS EG but not in Base SAS (when deployed a scheduled job through SAS Mamagement console). BASE SAS: libname CSCData access path='\\xxxxxx\00. Datastore\xxxxxData1.accdb'; ERROR: Connect: The Microsoft Access database engine cannot open or write to the file '\\xxxxxx\00. Datastore\xxxxxData1.accdb'. It is already opened exclusively by another user, or you need permission to view and write its data. ERROR: Error in the LIBNAME statement. SAS EG: libname CSCData access path='\\xxxxxx\00. Datastore\xxxxxData1.accdb'; NOTE: Libref CSCDATA was successfully assigned as follows: Engine: ACCESS Physical Name: \\xxxxxx\00. Datastore\xxxxxData1.accdb Any solution is greatly appreciated. Is there a OPTION statement to resolve this issue.
... View more
