1 User In BD At A Time

[skk]

I would like to have only one user to be able to open the DB at a time.
Right now I can have the DB open (working) and another user can open the same
DB and work in it at the same time. I went into TOOLS/OPTIONS/ADVANCED/ and
changed the open mode to EXCLUSIVE but multiple users can continue to open
the DB at the same time.

This is a 2003 Access DB

Can I have only one user able to open the DB at a time?


Thanks for all help.

 

[Jerry Whittle]

Create a shortcut with a command line something like below. Make sure that
the path to MSAccess.exe is correct as is the path and database names. Put
the shortcut on each user's desktop and make sure that they only start the
database using the shortcut:

"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "C:\Documents and
Settings\whittlej\PLAYGROUND.MDB" /excl

Of course this begs the question of why? One of the great advantages of
Access is that many people can use it at the same time.

 

[Klatuu]

If all users are using the same copy (bad idea), setting the open mode to
exclusive should do it; however, if each user has his own copy, there is no
easy way to determine another user has their copy open.

If it is a split database, you might try setting its open mode to exclusvie.
I haven't tested this, but it might be worth a shot.

 

[Dale Fye]

As Jerry says, why?

There are times, where I want to restrict access to the backend while I am
doing some maintenance or for some other reason. When this is the case, I
have a field [InMaintenance](Yes/No) in a table in the backend of the
database.

I have a function that allows me to change this value between Yes and No
whenever I want. Then, when a person logs onto the front-end, the splash
screen checks to see if that field is True or False. If it is true, I popup
a screen that says the database is in maintenance and advises them to check
back later, then closes the application. When I'm done doing my maintenance,
I change it back to No, and the other users are allowed access to the
database.

I actually take this one step further and have the Splash screen (hidden
after they have entered the application) timer event check that value every
couple of minutes. This way, if someone else is logged in, and I need to
force them off, I can do so elegantly.

HTH
Dale

 

[skk]

-Many thanks to you all. I see I have a lot to learn about access. I
thought I was a simple lock or unlock toggle....

Two other thing. I enter data into my form and close the form. When I
reenter the form it orders my entries by the PK. Can I not order the form by
PK and just have the order the entries by entry order?

And is it possible to move the RECORD: (counter at the bottom left) of the
form to the top right of the form.

Thanks again for all of your help.

SKK

As Jerry says, why?

There are times, where I want to restrict access to the backend while I am
doing some maintenance or for some other reason. When this is the case, I
have a field [InMaintenance](Yes/No) in a table in the backend of the
database.

I have a function that allows me to change this value between Yes and No
whenever I want. Then, when a person logs onto the front-end, the splash
screen checks to see if that field is True or False. If it is true, I popup
a screen that says the database is in maintenance and advises them to check
back later, then closes the application. When I'm done doing my maintenance,
I change it back to No, and the other users are allowed access to the
database.

I actually take this one step further and have the Splash screen (hidden
after they have entered the application) timer event check that value every
couple of minutes. This way, if someone else is logged in, and I need to
force them off, I can do so elegantly.

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

I would like to have only one user to be able to open the DB at a time.
Right now I can have the DB open (working) and another user can open the same
DB and work in it at the same time. I went into TOOLS/OPTIONS/ADVANCED/ and
changed the open mode to EXCLUSIVE but multiple users can continue to open
the DB at the same time.

This is a 2003 Access DB

Can I have only one user able to open the DB at a time?


Thanks for all help.

 

[Dale Fye]

1. If you want to present the records in your form in a particular order,
you need to create a query that includes an Order By clause.

2. If you create your own navigation buttons, you can put them and the # of
## box wherever you want it them. If you use the Access NavigationButtons,
you are stuck with the bottom left.

Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

-Many thanks to you all. I see I have a lot to learn about access. I
thought I was a simple lock or unlock toggle....

Two other thing. I enter data into my form and close the form. When I
reenter the form it orders my entries by the PK. Can I not order the form by
PK and just have the order the entries by entry order?

And is it possible to move the RECORD: (counter at the bottom left) of the
form to the top right of the form.

Thanks again for all of your help.

SKK

As Jerry says, why?

There are times, where I want to restrict access to the backend while I am
doing some maintenance or for some other reason. When this is the case, I
have a field [InMaintenance](Yes/No) in a table in the backend of the
database.

I have a function that allows me to change this value between Yes and No
whenever I want. Then, when a person logs onto the front-end, the splash
screen checks to see if that field is True or False. If it is true, I popup
a screen that says the database is in maintenance and advises them to check
back later, then closes the application. When I'm done doing my maintenance,
I change it back to No, and the other users are allowed access to the
database.

I actually take this one step further and have the Splash screen (hidden
after they have entered the application) timer event check that value every
couple of minutes. This way, if someone else is logged in, and I need to
force them off, I can do so elegantly.

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

I would like to have only one user to be able to open the DB at a time.
Right now I can have the DB open (working) and another user can open the same
DB and work in it at the same time. I went into TOOLS/OPTIONS/ADVANCED/ and
changed the open mode to EXCLUSIVE but multiple users can continue to open
the DB at the same time.

This is a 2003 Access DB

Can I have only one user able to open the DB at a time?


Thanks for all help.