Link to home
Start Free TrialLog in
Avatar of xzhang
xzhang

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of ozphil
ozphil

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of xzhang
xzhang

ASKER

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.
Which version of Access are you using?
Avatar of xzhang

ASKER

It's version 7.0
There is a property 'exclusive' for the data control which you can set to False (multi-user) on loading form.