MS Access Simple question.......

[vinman]

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

[Adelle Hartley]

vinman <vineet33@hotmail.com> wrote in message
news:3a8da301$1@news.devx.com...
> 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.

I think what is happening, is that your mdb file is being opened in
"Exclusive" mode.

The simple way of dealing with this is to change the default mode that
Access
uses to open databases from "Exclusive" to "Shared". This is on the
Advanced
tab on the Options screen (that may vary in earlier versions of Access).
You will need to set this option on each computer that uses the database.

Look up "Exclusive" in the help file for more information. And then look up
"Permission", because ultimately you may want to restrict which users are
even allowed to open the database in "Exclusive" mode.

Adelle.

=============================================
Impress your friends. Become an SQL Guru. http://www.sql-guru.com

[magnus]

Hello,

one way to solve this problem is to biuld up a system table. When you start
the application an autoexec module writes say an "-1" into the system table.
When if somebody else wants to have access to this database the visual basic
code implemented can show a message saying "The database is currently in
use! Please try again later". I think application.end in the vba-code ends
Access after clicking okay in the message box.
For further information concerning this problem don't hesitate to contact
me.

"vinman" <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

[Larry Rebich]

Are you using 'native' Access or VB. If VB are you using DAO or ADO or some
other access method? If using DAO then you can try to open the database for
Exclusive use. It that fails then some other application has it open. If
using OpenDatabase then the second parameter is:

For Microsoft Jet workspaces, you can use the following values for the
options argument.

Setting Description
True Opens the database in exclusive mode.
False (Default) Opens the database in shared mode.


Cheers,
Larry Rebich

More tips link to:
http://www.buygold.net/tips.html

Please:
No personal e-mail questions :-)


"vinman" <vineet33@hotmail.com> wrote in message
news:3a8da301$1@news.devx.com...
>
> 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