Help on this error below!

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

Ryan

I have a database that exports information to excel. I copied my
database to a co workers computer and if works fine until today. Now
it gives me this error.

The Microsoft Jet database engine cannon open 'C:\Documents and
Settings\Desktop\Export to Excel.xls'. It is already open exclusively
by another user, or you need permission to view its data.

If its on his computer how can someone else be using it and if that's
not the reasoning why would he need permission now if the export
worked before, also what permission is needed? How can I resolve this
issue?

Ryan
 
This type of problem can sometimes occur IF a hidden version of excell
opened the spreadsheet but then was never properly closed.

To determine if that is what has the spread sheet open, close Access
and all visible copies of Excell and then do the Cntrl-Alt-Delete and
check to see if there is still a copy of excell open in the Task
Manager - Processess tab. Ending that process will clear up the lock
on the file.

Now how did it get into that state is a question of 1) making sure
that any time you open excell in your code you are sure to close it.
and 2) try to figure out what the user saw before the problem started.

Re-booting the computer obviously will also solve the lock but not the
necessarily the cause of the problem.

Ron
 
Back
Top