DBMS Access error

[CG11164]

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.

[SASKiwi]

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.

[CG11164]

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.

[Reeza]

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

proc product_status;run;

[CG11164]

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

[Reeza]

Try using ACCESSCS instead.

[Reeza]

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.

[CG11164]

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;

[Reeza]

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.

[CG11164]

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