MS Access Simple question.......

[dave]

Hello all

I have a problem regarding MS Access. I have 3 Access Files on a shared network.
There are say 2 users . Now if one user is working on one of the access file(
say c.mdb), i dont want the other user to open that access file . In other
sense i want to pop up a message box saying that file ( c.mdb ) is in use
and cannot be accessed.

How is it possible .I was told you can use COM or sessions can be created.

Any suggestions on this.

V

[Arthur Wood]

Dave (or is it Vineet?),
When the database is opened, open it For Exclusive Use. Then no one else
can open or access it, until to original opener closes it.

Arthur Wood


"dave" <vineet33@hotmail.com> wrote:
>
>Hello all
>
>I have a problem regarding MS Access. I have 3 Access Files on a shared
network.
>There are say 2 users . Now if one user is working on one of the access
file(
>say c.mdb), i dont want the other user to open that access file . In other
>sense i want to pop up a message box saying that file ( c.mdb ) is in use
>and cannot be accessed.
>
>How is it possible .I was told you can use COM or sessions can be created.
>
>Any suggestions on this.
>
>V
>

[vineet]

Hi arthur..

Thanks for the answer. But i am accessing the database through a combobox.
I have a table where there is the database name ( field 1) and path
( field 2). The combobox consists of data from field 1 and when i click on
the record ( database name in the combo box ) , i actually go in to that
database( via the path ).

My question is how can i avoid other users accessing the database , through
the GUI .

Thanks
Regards
Vineet

[Alex Kennedy]

This is real crude but you could check for the existence of the .ldb file
for the database - if this file is there then in means that at least one
person has the DB open. The .ldb file *should* be automatically deleted
when no-one else is using the DB. Also there are some "unsupported" API
functions for communicating with Access .ldb file but I can't remember where
I saw the info on them.

Btw, if you use this technique then I suggest that you still open up the DB
in exclusive access mode as well.

Alex


"vineet" <vineet33@hotmail.com> wrote in message
news:<3a914c0a$1@news.devx.com>...
>
> Hi arthur..
>
> Thanks for the answer. But i am accessing the database through a combobox.
> I have a table where there is the database name ( field 1) and path
> ( field 2). The combobox consists of data from field 1 and when i click on
> the record ( database name in the combo box ) , i actually go in to that
> database( via the path ).
>
> My question is how can i avoid other users accessing the database ,
through
> the GUI .
>
> Thanks
> Regards
> Vineet