自动注销ms Access [英] Auto Logoff of ms Access
问题描述
我管理在服务器上运行的访问数据库，并利用拆分表和前端选项.当我必须进行更新时，我必须将所有人都从数据库中删除，这通常很困难.总会有一两个人在下班后忘记注销，或者在请求时不退出.我发现有一些第三方访问应用程序说它们可以工作，但是我找不到任何适用于Access 2010的应用程序.我想在Access 2010中它们更改了用户权限的工作方式，这弄乱了以前的解决方案.
I manage an access database that runs on a server and utilizes the split tables and front end option. When i have to make updates i have to get everyone out of the database and this often is difficult. There is always one or two peopl who forget to log off after hours or dont exit when requested. I found a few third party access applications that say they work but i cant find any for access 2010. i guess in access 2010 they changed how user permissions work and this messes up the previous solutions.
谢谢
推荐答案
我没有尝试过这种方法，所以我无法验证它是否有效，但是您看到\尝试过这种方法吗?
I haven't tried this approach so I can't validate that it works, but have you seen \ tried this?
本质上来说，您的想法是在启动时打开并隐藏一个表单，该表单会定期查询表以查找注销标志.
Essentially the idea is you open and hide a form at startup that periodically queries a table in search of the log off flag.
如果未设置该标志，则表单将重置其计时器，并每隔一定的时间间隔再次查询.
If the flag is not set the form resets its timer and queries again at some regular interval.
如果设置了该标志，则会显示表格，并向用户显示一条消息，告知他/她将在X分钟内注销.倒数到0时，表单将关闭应用程序.
If the flag is set the form is displayed with a message to the user that he\she will be logged off in X minutes. When the countdown reaches 0 the form closes the application.
据我所知，此方法的最大关键是需要在后端数据库中设置该标志，以便所有前端客户端都可以看到相同的数据.
As far as I can tell, the biggest key to this approach is that the flag needs to be set in the back-end database so that all front-end clients see the same data.
这篇关于自动注销ms Access的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
