Exporting Data to Acess - Error

[shellp55]

Hello

I recently purchased a new computer (running Windows 10) and installed SAS on it.  When I tried to export to Access (.accdb) as I've done many times before, I get an error message indicating “failed to connect to the server”.  I think this has something to do with the Microsoft drivers but I'm not understanding what I need to do to fix this.  All assistance greatly appreciated, thanks.

[JBailey]

Hi @shellp55 

This issue may be caused by not having SAS/ACCESS Interface to PC Files installed and configured correctly, but I am guessing. 

If this is the case, you may want to contact SAS Tech Support for assistance.

Best wishes,

Jeff

[ballardw]

---

@shellp55 wrote:

Hello

I recently purchased a new computer (running Windows 10) and installed SAS on it.  When I tried to export to Access (.accdb) as I've done many times before, I get an error message indicating “failed to connect to the server”.  I think this has something to do with the Microsoft drivers but I'm not understanding what I need to do to fix this.  All assistance greatly appreciated, thanks.

---

Run this code:

Proc Setinit; run;

Look in the log for the output. If you do not have line similar to:

---SAS/ACCESS Interface to PC Files

Then it is definitely a license issue. You need that module for exporting to Excel/ Access.

If you do see a line like that then run:

Proc product_status;run;

Check to log to see if you have a line such as:

For SAS/ACCESS Interface to PC Files ...

If not then the installation did not include the part you need and should reinstall SAS making sure that the module is selected.

Or you may need to insure that the PC Files server installed and configured properly.

It may not hurt to share the code you used.

And which version of Access do you have on the machine?

[Reeza]

Did you upgrade SAS or is it the same version? Is your code using PCFILES? If so, did you install that component and have it running? And last but not least, if you changed versions, your code may need to change 😞

[shellp55]

Thanks for all the speedy responses!  I did as Jeff suggested and contacted SAS Tech and they were super speedy but I have another query out to them.  When I checked what was loaded it looks like those files are there but maybe not the correct ones.  I'm just waiting for confirmation on which download I need from the site and I will report back.

Just an FYI to any others using this, the latest SAS PC Files Server version is from June 2019 so you may need an update.

Shelley

[shellp55]

Hello

I was missing the proper files so they have now been loaded and everything works as it should.  Thanks everyone!