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

Allen Browne

Double-check you don't have Excel opened.
Close Access and try again.
If something crashed on your computer, reboot.

If you're still stuck after that, try a different folder such as your own My
Documents.
 
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
 
Top