Re: Releasing lock on MDB file after DataReport1 closes [multiposted]

From a post by Jeff Johnson:

"You have posted this question individually to
multiple groups. This is called Multiposting
and it's BAD. Replies made in one group will
not be visible in the other groups, which
may cause multiple people to respond to your
question with the same answer because they
didn't know someone else had already done it.
This is a waste of time.

If you MUST post your message to multiple
groups, post a single message and select all
the groups (or type their names manually,
separated by commas) in which you want it to
be seen. This is called Crossposting and when
used properly it is GOOD."

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--
Read. Decide. Sign the petition to Microsoft.
http://classicvb.org/petition/


"Martin A. Weinberger" <tg_mweinberger@butterflyvista.com> wrote in message
news:uTtfSFkYFHA.4024@TK2MSFTNGP10.phx.gbl...
> Hi all,
>
> I've noticed that if I call DataReport1.Show that after I regain control
> after that call that the MDB file that the report used still has a lock on
> it, as is evident by the LDB file. I've even tried calling "Unload
> DataReport1" and still the same thing. Only when my application closes
does
> the DataReport release the lock. I've tried capturing the Terminate event
> and manually closing the connection, but that didn't do anything.
>
> Thank you in advance for any assistance.
>
> --
> Martin A. Weinberger
> ButterflyVista
> http://www.butterflyvista.com/
>
>