How to unlock a access .mdb file?

Sometime when I use vb programming a access database, unexpectly,
my vb app shut down , then I can't access that .mdb
any more, it says some other app open the file exclusively
and lock it. how can I solve this problem and avoid this kind of thing happen again?
Thanks a lot.
xzhangAsked:
Who is Participating?
 
ozphilConnect With a Mentor Commented:
Well your application was the one that had locked the database.

As a quick workaround, you could open the database in shared mode.

Bu am i stating the obvious. :)
0
 
xzhangAuthor Commented:
Can you tell me how to open database in share mode in vb
data control. Is it just a property to set,or I have to
use a function to open database.
Thanks.
0
 
ozphilCommented:
Which version of Access are you using?
0
 
xzhangAuthor Commented:
It's version 7.0
0
 
ozphilCommented:
There is a property 'exclusive' for the data control which you can set to False (multi-user) on loading form.






0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.