opening a db exclusively

[AMC]

Hi,

Is there a way to have an Access db only open by one user at a time? I would
like a message to display if one user has the file open and another user
attempts to open that same file.

Thanks,
AC

 

[Van T. Dinh]

Use the Menu Tools / Options... / Advanced tab / Default Open Mode pane and
select the option you want.

 

[AMC]

I did this and set the option to open the db exclusively, but this doesn't
accomplish my goal. I only want one user at a time in the database and this
option still allows multiple users to open the file simultaneously.

Thanks
AC

 

[Van T. Dinh]

I just tested in A2K2 and open the database exclusively. Then I tried to
open the same database with the second instance of Access (shared) and I
couldn't with error message "File currently in use".

Beware that if you use the MRUs, the MRUs remember which mode the database
was opened previously and will open the database the same mode regardless of
the new setting in Options...

Also, you users may have shortcuts the specify open in shared mode that can
overide the Default Open Mode ...

 

[AMC]

Thanks, but what are MRU's

I just tested in A2K2 and open the database exclusively. Then I tried to
open the same database with the second instance of Access (shared) and I
couldn't with error message "File currently in use".

Beware that if you use the MRUs, the MRUs remember which mode the database
was opened previously and will open the database the same mode regardless of
the new setting in Options...

Also, you users may have shortcuts the specify open in shared mode that can
overide the Default Open Mode ...

 

[AMC]

This is what I just tried to open the database twice at the same time on the
same machine with two different instances of Access 2000 and it opened both
times. I'm not getting the file in use message on the second open even
though the option is set to exclusive, any other ideas?

 

[Van T. Dinh]

MRUs: Most-Recently Used databases. They are the ones that appear in the
lower part of the File Menu.

 

[Van T. Dinh]

The "Open" command in the Database File opening dialog is a ComboBox. Drop
this one down and select "Open Exclusive".

 

[AMC]

Hi,

Thanks for the info. I need to create a shortcut to put on the user's
desktop that opens the db exclusively
how would I do this?

Thanks

 

['69 Camaro]

Hi, AMC.

To open the database file exclusively with a shortcut, type the paths, file
names and command-line switch like the following in the shortcut's Target
field:

"C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:\Program
Files\Microsoft Office\Office\samples\northwind.mdb" /Excl

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

 

[Van T. Dinh]

Also see Access Help topic "Startup Command-line options"
for different options you can use including /Excl.

HTH
Van T. Dinh
MVP (Access)

 

[AMC]

Thanks

Also see Access Help topic "Startup Command-line options"
for different options you can use including /Excl.

HTH
Van T. Dinh
MVP (Access)