B
Ben
Hi all,
I have two forms in my Access database. I also have a few tables that are
linked to another Access database, in which the owner needs exclusive locking
to its tables all the time. I need to query a few of his databases tables
without exclusive lock. In fact, I would like to set my queries so that it
is just read only.
The query on form1 calls a prebuild query and queries the tables in owner's
database. It does this by using a TimeInterval of everyone 1 minute. The
form1's code does a Me.Requery base on this time interval. Is there any way
to not lock the database owner's tables and accomplish what I need? Thanks.
Ben
--
I have two forms in my Access database. I also have a few tables that are
linked to another Access database, in which the owner needs exclusive locking
to its tables all the time. I need to query a few of his databases tables
without exclusive lock. In fact, I would like to set my queries so that it
is just read only.
The query on form1 calls a prebuild query and queries the tables in owner's
database. It does this by using a TimeInterval of everyone 1 minute. The
form1's code does a Me.Requery base on this time interval. Is there any way
to not lock the database owner's tables and accomplish what I need? Thanks.
Ben
--