opening a db exclusively

A

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
 
V

Van T. Dinh

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

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
 
V

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 ...
 
A

AMC

Thanks, but what are MRU's

Van T. Dinh said:
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 ...
Click to expand...
 
A

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?
 
V

Van T. Dinh

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

Van T. Dinh

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

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
 
6

'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.
 
V

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)
 
A

AMC

Thanks
Van T. Dinh said:
Also see Access Help topic "Startup Command-line options"
for different options you can use including /Excl.

HTH
Van T. Dinh
MVP (Access)
Click to expand...
 
Top