problems with accessing accdb files

BartDekeyser — Wed, 03 Mar 2021 10:55:51 GMT

Hi all,

my colleague has a problem with following statement :

libname dbacc Access Path="C:\test.accdb";

in my sasstudio environment it works without a problem. I can even use following statements to achieve the same:

libname dbacc Access "C:\test.accdb";

libname dbacc "C:\test.accdb";

With him it causes a peer exception and it shuts down the sas studio.

Does anyone can tell me what i can do. We both use the same server location.

Re: problems with accessing accdb files

SASJedi — Wed, 03 Mar 2021 13:04:57 GMT

What version of SAS are you each running? If the problem is with the SAS University Edition, have a look at a possible solution here: