Charles Tam said:
Thanks for your reply.
How could I ensure the linked-table is not being used by something else,
hence available for modification. Note, I have no control over the
linked-table since it is external to my Access application.
Alternatively, please suggest another approach I should be taking.
If you mean that you want to know whether your linked table is available for
modification by some other application, then no, you can't discover that
from within your Access application. Also, you say that you want to make
sure it is NOT being "used" by something else, but you also say that you
have no control over it. So how can you possibly prevent anything else
using it if you have no control over it?
If you want to know whether it has BEEN modified by something else, that
depends on what it is. If it's a Windows file (say, a spreadsheet) you
could check it's modified date. If it's, say, a SQL Server table, then you
are really dependent on whether there are updated/inserted timestamps in the
table.
You really need to be a lot clearer about what it is you are trying to
achieve, and why.
