I have this error. how do I fix this?

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.
 
R

Ron2006

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top