Re: Restrict FE application to one user at a time - "Exclusive" isn't Exclusive!
- From: "paii, Ron" <paii@xxxxxxxxxxxxxx>
- Date: Mon, 30 Apr 2007 08:43:44 -0500
<teddysnips@xxxxxxxxxxx> wrote in message
news:1177928138.876356.204410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On 12 Mar, 15:43, "Keith Wilby" <h...@xxxxxxxxx> wrote:"Exclusive"
<teddysn...@xxxxxxxxxxx> wrote in message
news:1173710008.111930.56570@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
They want to amend it so that only one person can be logged in at any
one time. So, if Joe Bloggs tries to open the application, and Fred
Jones has already connected, Joe Bloggs will see a message saying
"System exlusively opened by Fred Jones. Please try later" or
something like that, and Access would then close.
I think this is achievable by checking the default open mode to
The "Exclusive" setting is for the front end. You could try opening the backunder Tools, Options, Advanced.
Hi Keith
I've finally got around to testing this.
I created a dummy back-end with a single table and, as you suggested,
set the default open mode to "Exclusive". I moved this database to a
location on our network.
I also created a dummy front-end linked to the dummy back-end, also
setting the default open mode to "Exclusive". I sent a copy to a
colleague and we were both able to open the front-ends
simulataneously, editing the data ad lib.
Any thoughts?
Edward
end tables and place a lock on the tables using VBA code in the front end.
.
- References:
- Prev by Date: Re: Open Form, based on a table, to specific record from another form
- Next by Date: CreateForm Help
- Previous by thread: Re: Restrict FE application to one user at a time - "Exclusive" isn't Exclusive!
- Next by thread: Re: Restrict FE application to one user at a time - "Exclusive" isn't Exclusive!
- Index(es):
Relevant Pages
|
