"exclusively in use" problem

[Alvey Sidecast]

Struggling even more than usual here.
I've (nearly) written an XP application but have this problem where I
can't delete any records from the table my subform is based on. The
message I keep getting is "the table xxxxx is being used exclusively
by another user....blah blah". That's one problem, but the more
frustrating problem is; why can I close the Form and then successfully
run a Delete query but can't do these two steps in a macro?

Can anyone explain why this is so?


tia

[Uttam]

Re: "exclusive ly in use" problem

One way out would be to copy all the records from the table / query
referred to in the recordsource of the subform and deleting in that
copy and then changing the record source to the copied table/query.

The reason most probably is because your application's form navigation
is as follows:

1) You have a main form on which you click a button to open another
form on which this subform is.

2) When you open, you may have used the usual Access provided facility
of DoCmd.OpenObjec t "another-form-name"

3) Realise that control is still with the function which has opened
the form in step 2.

4) Till such time that that function does not relinquish control, you
will not be able to delete records from that table.

I encountered a similar problem as you have described. I am currently
developing the logic to overcome this problem in the way I have
described above.

Hope this helps.

Cheers!

Uttam

=============== ======
alvey_sidecast@ yahoo.com (Alvey Sidecast) wrote in message news:<edfd90c9. 0310010054.7f41 0885@posting.go ogle.com>...[color=blue]
> Struggling even more than usual here.
> I've (nearly) written an XP application but have this problem where I
> can't delete any records from the table my subform is based on. The
> message I keep getting is "the table xxxxx is being used exclusively
> by another user....blah blah". That's one problem, but the more
> frustrating problem is; why can I close the Form and then successfully
> run a Delete query but can't do these two steps in a macro?
>
> Can anyone explain why this is so?
>
>
> tia[/color]