Solved

How to unlock a access .mdb file?

Posted on 1997-10-13
5
266 Views
Last Modified: 2010-05-18
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.
0
Comment
Question by:xzhang
  • 3
  • 2
5 Comments
 
LVL 4

Accepted Solution

by:
ozphil earned 50 total points
ID: 1957111
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
 

Author Comment

by:xzhang
ID: 1957112
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
 
LVL 4

Expert Comment

by:ozphil
ID: 1957113
Which version of Access are you using?
0
 

Author Comment

by:xzhang
ID: 1957114
It's version 7.0
0
 
LVL 4

Expert Comment

by:ozphil
ID: 1957115
There is a property 'exclusive' for the data control which you can set to False (multi-user) on loading form.






0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question