Good evening I am trying to resolve an issue with export to a file which is an access database file.  They execute the SAS script that updates this accdb file on the :drive but the user is receiving file already in use.  I tried to use a backup of the file but getting the same results.  Also trying to help the guys who made some security changes to the server figure out if it's something that locked the file.  Any thoughts or assistance would be greatly appreciated. when I click on the file the Access database opens fine.  Seem like we just can't update it/export to it.   Error below:     NOTE: There were 101 observations read from the data set ABCOSPPS.SADJ_DDCT. NOTE: The data set ABCOSPPS.SADJ_DDCT_BASIC has 101 observations and 14 variables. NOTE: DATA statement used (Total process time):       real time           0.10 seconds       user cpu time       0.01 seconds       system cpu time     0.04 seconds       memory              662.28k       OS Memory           15760.00k       Timestamp           12/31/2021 11:12:16 AM       Step Count                        7  Switch Count  0     NOTE: %INCLUDE (level 1) ending. 1468  PROC EXPORT DATA= ABCOSPPS.Sadjustment 1469              OUTTABLE= "Adjustment" 1470              DBMS=ACCESS REPLACE; 1471       DATABASE="S:\sas\\access\ABCOSPPS_Current.accdb"; 1472  RUN;   ERROR: Connect: Could not use 'S:\sas\\access\ABCOSPPS_Current.accdb'; file        already in use. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time):       real time           1.40 seconds       user cpu time       0.09 seconds       system cpu time     0.21 seconds       memory              1055.15k       OS Memory           16016.00k       Timestamp           12/31/2021 11:13:23 AM       Step Count                        8  Switch Count  0     ... View more

Hi all,  we users when executing scripts are getting the below errors.  I have never encountered these errors. Can anyone point me in the right direction.  It seem like the users are getting this with any IMPORT or EXPORT of Excel generated files.  Thanks.   ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. ERROR: Connection Failed.  See log for details. NOTE: The SAS System stopped processing this step because of errors. ... View more

ERROR: Insufficient space in file WORK.'SASTMP-000000072'n.UTILITY. NOTE: File WORK.'SASTMP-000000072'n.UTILITY is damaged. I/O processing did not complete. WARNING: Limited resources when loading index Thanks any help or advice would be appreciate ... View more

User receiving ERROR: A lock is not available for XXXX.XXXX_SSN.DATA   and ERROR: A lock is not available for XXXX.XXXX_SSN.INDEX The table is created user says everything is not complete.  I Thought the below was implying that some else has a lock on the entity.  Just trying to get an idea of what to check or verify...   NOTE: SAS threaded sort was used. NOTE: Table PXXXX.XXXX_SSN created, with 645293 rows and 2 columns.   98  + 99  + NOTE: PROCEDURE SQL used (Total process time):       real time           14:05.97       user cpu time       6.25 seconds       system cpu time     4.09 seconds       memory              269208.58k       OS Memory           279004.00k       Timestamp           05/04/2020 04:37:46 PM       Step Count                        3  Switch Count  0     100 +Proc SQL; 101 +create Index ssn on pcxxx.xxxt_ssn( 102 +                       ssn 103 +); ERROR: A lock is not available for PXXX.XXXX_SSN.DATA. 104 + 105 +quit; I ... View more