asked on
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
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
Microsoft AccessMicrosoft Excel
Last Comment
wgraphics
no attachment provided
ASKER
Woops. Thanks
error.bmp
error.bmp
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".
The question has either no comments or not enough useful information to be called an "answer".
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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
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