Checking Linked Table Usage

C

Charles Tam

Is there a way to check whether a linked table is being used by another
process?
 
J

Jeff Boyce

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.
 
C

Charles Tam

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.
 
B

Brian

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.
 
C

Charles Tam

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?
 
B

Brian

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!
 
Top