Checking Linked Table Usage

  • Thread starter Thread starter Guest
  • Start date Start date
Charles

Unless you have a one-row table, or unless there's a chance the same record
might be "used" by more than one user/process, I'm not clear on why this
might be an issue.
 
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.
 
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.
Click to expand...

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.
 
Thanks for your update and sorry about the confusion.

I would like to find out how to modified records in a link table while it is
being modified by someone else?
 
Charles Tam said:
Thanks for your update and sorry about the confusion.

I would like to find out how to modified records in a link table while it is
being modified by someone else?
Click to expand...

Sorry, that's no clearer!
 
Back
Top