VB Forum / Database Access / May 2005

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

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

Data bound controls tend to maintain persistent connections throughout the life of the application.
I'm not sure what your DataSource is but if it's the Data Control then that would explain the
behavior.

Paul
~~~~
Microsoft MVP (Visual Basic)