File Now Available box appears- how do I stop this?

Hello
We have a database that was built with Access 2003 and I am running Excel 2007 on my pc.

This database was built years ago and is only used a couple times a year to generate reports for a certain client.

Here's the process that is giving me trouble-

1. The client sends us an Excel file
2. We launch a From in Access. Click the custom Import button.
3. Normally, it would just import and we could go onto the next step.

But now we are getting the File Now Available box (see attachment)-
Why?

If I choose Read-Write, everything freezes.
If I choose Cancel, everything freezes.

I have to Ctrl+alt+delete | Task Manager and End Task.

I appreciate any insight you might have.
Megan
wgraphicsAsked:
Who is Participating?
 
Dale FyeCommented:
wgraphics,

Are you still interested in this?  I don't know how I let this slip through the cracks.  this message is generally visible when someone else is using the file and you try to open it.  Is there a possibility that that was happening?

Another issue might be that the file is already open on your machine (the machine running the code) and the Access code is opening another instance of Excel and opening a second instance of this form.  If that is the case, then checking to see whether an  instance of Excel is already open (use GetObject) rather than creating a new instance of Excel (with CreateObject) might resolve this issue.

Dale
0
 
Dale FyeCommented:
no attachment provided
0
 
wgraphicsAuthor Commented:
Woops. Thanks
error.bmp
0
 
Martin LissOlder than dirtCommented:
I've requested that this question be deleted for the following reason:

The question has either no comments or not enough useful information to be called an "answer".
0
 
wgraphicsAuthor Commented:
Dale,
No one would have had it open at the time I was working on it, but, you said "Another issue might be that the file is already open on your machine (the machine running the code) and the Access code is opening another instance of Excel and opening a second instance of this form" and I  bet that is what was happening. I haven't had a chance to test, but I will. Thanks for taking the time to reply. Megan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.