topic Re: DBMS Access error in SAS Programming

DBMS Access error

CG11164 — Wed, 24 Jul 2019 18:30:35 GMT

Any suggestions for what is causing this error? I am getting it on all PROC IMPORT OUT with Access

Relatively new to SAS programming so any suggestions are appreciated. Using SAS 9.4 running 32 bit on 64 bit machine with 32 bit office.

PROC IMPORT OUT= &curlib..CountsAll

27 DATATABLE= "CountsPool"

28 DBMS=ACCESS REPLACE;

ERROR: DBMS type ACCESS not valid for import.

Re: DBMS Access error

SASKiwi — Wed, 24 Jul 2019 19:39:46 GMT

That is the message you get when SAS and Access do not have the same bitness.I'm guessing your SAS is 64-bit as that is most common these days.

Please check if SAS / Access are either both 32-bit or 64-bit. In SAS choose Help / About.

Re: DBMS Access error

CG11164 — Wed, 24 Jul 2019 19:51:29 GMT

SAS help desk had me install the 32 bit SAS version on my 64 bit machine so it would work better with the 32 bit office. They said I should not be getting this error however, still getting it.

Re: DBMS Access error

Reeza — Wed, 24 Jul 2019 20:30:18 GMT

Do you have the appropriate things installed?
Can you run the following and post the results from the log:

proc product_status;run;

Re: DBMS Access error

CG11164 — Wed, 24 Jul 2019 20:32:57 GMT

proc product_status;run;

For Base SAS Software ...

Custom version information: 9.4_M6

Image version information: 9.04.01M6P110718

For SAS/STAT ...

Custom version information: 15.1

For SAS/GRAPH ...

Custom version information: 9.4_M6

For High Performance Suite ...

Custom version information: 2.2_M7

For SAS/ACCESS Interface to PC Files ...

Custom version information: 9.4_M6

NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):

real time 0.04 seconds

cpu time 0.01 seconds

Re: DBMS Access error

Reeza — Wed, 24 Jul 2019 20:35:33 GMT

Try using ACCESSCS instead.

Re: DBMS Access error

Reeza — Wed, 24 Jul 2019 20:36:17 GMT

If that doesn't work, can you please show the code used, without macro variables and including the full log as well that shows the error generated.

Re: DBMS Access error

CG11164 — Wed, 24 Jul 2019 20:49:49 GMT

Code:

libname GRPDB "C:\Users\one\Documents\Group";

%let curlib=cgDB;

%let accessdb="C:\Users\one\Documents\SAS Files\GroupSAS.mdb";

options fmtsearch=(sasuser &curlib.);

options cmplib=sasuser.funcs;

PROC IMPORT OUT= &curlib..CountsAll

DATATABLE= "Counts"

DBMS=ACCESSCS REPLACE;

DATABASE=&accessdb.;

SCANMEMO=YES;

USEDATE=YES;

SCANTIME=NO;

RUN;

PROC IMPORT OUT= &curlib..SummaryT

DATATABLE= "CountsAct"

DBMS=ACCESSCS REPLACE;

DATABASE=&accessdb.;

SCANMEMO=YES;

USEDATE=YES;

SCANTIME=NO;

RUN;

Re: DBMS Access error

Reeza — Wed, 24 Jul 2019 21:21:26 GMT

Not trying to be a giant pain, but that log and code do not go together - the log is not from the code shown. Can you please show exactly the code you ran and the log with errors, once using Access and once using accesscs.

Re: DBMS Access error

CG11164 — Wed, 24 Jul 2019 21:34:26 GMT

Tried to remove company info and apparently it didn't work. let me get you a clean slate of the code and runs. Thanks