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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ozphilCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.