I have this error. how do I fix this?

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

I have vba code where when I run the macro it will download a
Microsoft Access table into Excel. Now all of a sudden I get this
error. It says.

"The Microsoft Jet Database cannot open the file 'C:\Desktop\file.xls'
It is already opened exclusively by another user, or you need
permission to view its data."

How do I fix this?

Ryan

I did post this on another thread but since there were 4 posts in the
last few months I thought I could get help here.
 
If the job has failed be aware that excell could still be open in the
background.

you may need to do a <Cntrl-Alt-Delete> and check in the task manager
in the processes tab for an instance of Xcell running in the
background. You may need to close it to continue with the access part.

Ron
 
Back
Top