BookmarkSubscribeRSS Feed
O_Lavrentii
Calcite | Level 5

proc IMPORT out=data

datatable='data'

dbms=access replace;

database='c:\user\database2.accdb';

run;

an error occurred during the execution of this code

I just start my work with SAS and will so appriciate if you could help my to solve this problem)

4 REPLIES 4
O_Lavrentii
Calcite | Level 5

ERROR: Unable to open file C:\Users\Database2.accdb. It does not  exist or it is already opened exclusively by another user, or you need permission to view its data.

my win 64

mohamed_zaki
Barite | Level 11

Did you make sure that this is the right dir?

Also what is your sas version and is it 32 or 64?

jakarman
Barite | Level 11

add to that list of questions on the environment.

Client/Server approach or a standalone desktop version.

When Client/Server the version/type of the SAS/Server process and whether access pcfiles is licensed.

I am guessing it is a Windows server based one.

---->-- ja karman --<-----
O_Lavrentii
Calcite | Level 5

ERROR: Unable to open file . It does not  exist or it is already opened exclusively by another user, or you need permission to view its data.

There is some special requirements for access files?

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1256 views
  • 1 like
  • 3 in conversation