I have an MS Access file linked to 8 Excel files which
users make updates to. In Access I combine and process
the data into a view which is imported by a 9th Excel
file.
In other words from the 9th Excel file I have code which
Imports the processed data from the Access file which is
getting its data from the 8 othe Excel files.
Now that you are probably thoroughly confused, this is the
problem: When I run the code to import from file #9, all
8 of the other Excel files open. If there are links in
the other files, I get the "Update Links" question. If
the files are already open, I get the "read only" request.
How can I keep this from happening? When I run the SQL
from Access, this doesn't happen.