一次将FE应用程序限制为一个用户 [英] Restrict FE application to one user at a time
问题描述
我的一位客户要求我更改其中一个Access
申请。
该应用程序是前端/后端标准应用程序我没有开发它，但看着它告诉我它是完全使用巫师完成的。没有登录程序。
他们想要修改它，这样一次只能有一个人登录任何
。因此，如果Joe Bloggs试图打开该应用程序，并且Fred已经连接了这个消息，那么Joe Bloggs将会看到一条消息，说明由Fred Jones独家开放的系统。请稍后再试或者
之类的东西，Access就会关闭。
我的第一个想法如下。
创建一个Users用户表，将用户与其网络名称相匹配。
创建一个LoggedIn表来存储登录用户的详细信息。这个
表只有一行。一旦用户完成
工作并关闭应用程序，该行将被删除。
如果用户试图连接，应用程序将只是在这个LoggedIn表中检查
是否存在一行。
我唯一担心的是确保该行总是被删除但是
用户退出应用程序 - 有没有人有过这个
的经验以及对可能陷阱的任何想法？对于一天的工作，只有足够的钱
，所以我对镀金不感兴趣。
TIA
爱德华
< te ******** @ hotmail。在消息中写道
news：11 ********************* @ h3g2000cwc.googlegrou ps.com ...
< blockquote class =post_quotes>
>
他们想要修改它，这样一次只能有一个人登录任何
。因此，如果Joe Bloggs试图打开该应用程序，并且Fred已经连接了这个消息，那么Joe Bloggs将会看到一条消息，说明由Fred Jones独家开放的系统。请稍后再试或者
这样的东西，然后Access就会关闭。
我认为这可以通过将默认的开放模式检查为Exclusive来实现。 ;
在工具，选项，高级下。
基思。
www.keithwilby.com
3月12日15:43，Keith Wilby < h ... @ there.comwrote：
< teddysn ... @ hotmail.comwrote in message
新闻：11 ********************* @ h3g2000cwc.googlegrou ps.com ...
他们想要修改它，这样一次只能有一个人登录任何
。因此，如果Joe Bloggs试图打开该应用程序，并且Fred已经连接了这个消息，那么Joe Bloggs将会看到一条消息，说明由Fred Jones独家开放的系统。请稍后再试或者
这样的东西，然后Access将关闭。
我认为这可以通过在工具，选项，高级下检查默认打开模式为独家
来实现。
嗨Keith
我终于开始测试了这个。
我创建了一个带有单个表的虚拟后端，并且如您所建议的那样，
将默认打开模式设置为Exclusive。我将这个数据库移动到我们网络上的一个
位置。
我还创建了一个与虚拟后端相连的虚拟前端，也是
将默认打开模式设置为Exclusive。我发了一份副本给了一个
的同事，我们都能同时打开前端
，自行编辑数据。
有什么想法吗？
爱德华
< te ********@hotmail.com写信息
新闻：11 ********************** @ c35g2000hsg。 googlegr oups.com ...
我终于开始测试了这个。
我创建了一个假人后端有一个表格，如你所说，
将默认的开放模式设置为独家。我将这个数据库移动到我们网络上的一个
位置。
我还创建了一个与虚拟后端相连的虚拟前端，也是
将默认打开模式设置为Exclusive。我发了一份副本给了一个
的同事，我们都能同时打开前端
，自行编辑数据。
有什么想法吗？
该设置适用于您安装Access，而不适用于您目前正在打开的单个文件。我也很确定它只影响前端，
不是后端。
-
Rick Brandt ，Microsoft Access MVP
电子邮件（视情况而定）至...
来自Hunter dot的RBrandt
One of my clients has asked me to make a change to one of their Access
applications.
The application is a Front End/Back End standard app. I didn''t
develop it, but looking at it tells me that it was done entirely using
the Wizards. There is no log-in procedure.
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.
My first thought is as follows.
Create a Users table matching users to their network name.
Create a LoggedIn table to store details of the logged-in user. This
table would only ever have one row. Once the user had finished their
work and closed the app., the row would be deleted.
If a user tried to connect, the application would simply check for the
existence of a row in this LoggedIn table.
My one concern is to ensure that the row is ALWAYS deleted however the
user exits the application - has anyone had any experience with this
and any thoughts about possible pitfalls? There''s only enough money
for one day''s work, so I''m not interested in gold-plating.
TIA
Edward
<te********@hotmail.comwrote in message
news:11*********************@h3g2000cwc.googlegrou ps.com...>
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 "Exclusive"
under Tools, Options, Advanced.
Keith.
www.keithwilby.com
On 12 Mar, 15:43, "Keith Wilby" <h...@there.comwrote:<teddysn...@hotmail.comwrote in message
news:11*********************@h3g2000cwc.googlegrou ps.com...
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 "Exclusive"
under 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
<te********@hotmail.comwrote in message
news:11**********************@c35g2000hsg.googlegr oups.com...
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?That setting is for your installation of Access, not for the individual file you
currently are opening. I''m also pretty sure that it only affects front ends,
not back ends.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
这篇关于一次将FE应用程序限制为一个用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
