D
Dkline
I have a database in which most of the tables are linked Excel files (about
20). Several coworkers "own" these files and update them periodically. When
they have the file open, seemingly I can't use it.
Every one of my queries is set to "Snapshot". I was kind of hoping that by
not permitting any changes to be made by my application, it would gracefully
ignore that the Excel file was currently being edited.
Purpose of the application is to give senior management a "snapshot" of
sales, etc. by producer, by client, by manufacturer, etc., whenever they
need it. When they need it, they're not going to want to be told "Can't have
it because a file is open."
How can I fix this problem?
1. Create a folder and copy the various Excel files from their "active"
folders to the new folder to be used by Access? Basically I copy in the
files once/day and work with the copies.
2. Is there something I can set in Access to say just get me the stuff from
the Excel file even though it is being edited? Read-only? Snapshot?
3. Something in VBA?
20). Several coworkers "own" these files and update them periodically. When
they have the file open, seemingly I can't use it.
Every one of my queries is set to "Snapshot". I was kind of hoping that by
not permitting any changes to be made by my application, it would gracefully
ignore that the Excel file was currently being edited.
Purpose of the application is to give senior management a "snapshot" of
sales, etc. by producer, by client, by manufacturer, etc., whenever they
need it. When they need it, they're not going to want to be told "Can't have
it because a file is open."
How can I fix this problem?
1. Create a folder and copy the various Excel files from their "active"
folders to the new folder to be used by Access? Basically I copy in the
files once/day and work with the copies.
2. Is there something I can set in Access to say just get me the stuff from
the Excel file even though it is being edited? Read-only? Snapshot?
3. Something in VBA?