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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
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
Dale FyeOwner, Developing Solutions LLCCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.