how to detect erros on loading subform

[Welie]

I apologize if this is a faq. I searched for about 45 minutes and
didn't find a good answer but there are many matching posts.

I have a form which is based on a simple query to a linked table. The
data is set to no edits,additions,deletions,dataEntry. If the form is
open, but the linked table is opened seperately in design mode, than a
message appears saying "the table is already opened exclusively by
another user". Which makes perfect sense. I am able to detect the error
and respond accordingly.

But here is the problem. This form is also used as a subform on a tab
control page. In that case, Access doesn't throw an error, I can't
detect the error, and the subform is just blank.

How do I detect the error that the subform can't load?

[Keith Wilby]

"Welie" <we******@gmail.com> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com...

If the form is
open, but the linked table is opened seperately in design mode, than a
message appears saying "the table is already opened exclusively by
another user". Which makes perfect sense. I am able to detect the error
and respond accordingly.

I would say that, operationally, you should never encounter such a scenario.
As the developer, surely you would never have the need to generate it. Have
you split your database into front/back ends? Have you coded a method to
exclude all users whilst you work on the BE tables in design mode?

Just my 2p worth :-)

Keith.
www.keithwilby.com

[Welie]

>>If the form is

open, but the linked table is opened seperately in design mode, than a
message appears saying "the table is already opened exclusively by
another user". Which makes perfect sense. I am able to detect the error
and respond accordingly.

I would say that, operationally, you should never encounter such a scenario.
As the developer, surely you would never have the need to generate it. Have
you split your database into front/back ends? Have you coded a method to
exclude all users whilst you work on the BE tables in design mode?

I'm still a newbie for these kind of things. I didn't code anything to
exclude users. This is a split database. I would imagine there are also
other scenarios where a table could be locked and the recordset not
retreivable.

I did come up with a way to check, but its a bit of a hack. When the
user clicks on the tab I check a property of the subform recordset. If
it generates a 3008 error, I through up an error mesage.

Again I would imagine there could be other times when a table is locked
that a query can't execute. So this hasn't this got to be a more
generic scenario?