J
John Donofrio
Hello,
I am working on an MDB that stores data for use in an
Excel file and a Word Doc. The data in both these files is
linked (XLS to MDB, and DOC to XLS). The MDB performs
updates to the other two files when data has changed. I do
not want automatic updates since the DOC file will be
delivered to other locations that will not have access to
the DataSource files.
Here is the issue:
In Excel I can detect when the file is open by another
user and not available for updates, then relay this to the
user via a MsgBox. In Word, however, I get the subject
dialog when the DOC is open by another user. I would like
to supress this dialog and test for ReadOnly and then let
the user know this file is not available for updates since
it is open by another user.
Any ideas / tips?
Thanks in advance,
John
I am working on an MDB that stores data for use in an
Excel file and a Word Doc. The data in both these files is
linked (XLS to MDB, and DOC to XLS). The MDB performs
updates to the other two files when data has changed. I do
not want automatic updates since the DOC file will be
delivered to other locations that will not have access to
the DataSource files.
Here is the issue:
In Excel I can detect when the file is open by another
user and not available for updates, then relay this to the
user via a MsgBox. In Word, however, I get the subject
dialog when the DOC is open by another user. I would like
to supress this dialog and test for ReadOnly and then let
the user know this file is not available for updates since
it is open by another user.
Any ideas / tips?
Thanks in advance,
John