空闲的紧凑BE ...太混乱了！ [英] Compact BE while idle... so confused!

问题描述

我搜索了网站，可能发现了几十个帖子......我对这些回复感到有些困惑...这是我的情况，看看是否

有人可以指示我去哪里：


我已将数据库拆分为FE和BE，我想在以下情况下自动压缩BE：

1。所有用户退出FE（或者如果没有在一天中的某个时间退出并且

是空闲的（忘记退出），强迫他们退出它来做一个紧凑的）

或

2.最后一个人无法访问BE（FE已退出）


提前致谢，

Perry

I have searched the site and probably came across dozens of posts... I
am somewhat confused about the replies... here is my situation, see if
someone can point me to where to go:

I have splitted up the DB to FE and BE, I want to autocompact BE when:
1. all users exited FE (or if not out by certain time of the day and it
is idle (forgot to logout), force them out of it to do a compact)
or
2. Last person out of accessing the BE (FE exited)

Thanks in advance,
Perry

推荐答案

pe ****** @ yahoo.com 写道：

我搜索了网站，可能发现了几十个帖子...我

我对这些回复感到有些困惑......这是我的情况，看看是否有人可以指示我去哪里：


我已经分手了他将数据库转换为FE和BE，我希望在以下情况下自动压缩BE：

1.所有用户退出FE（或者如果一天中的某个时间没有退出，则

它是闲置（忘记注销），强行退出它们做一个紧凑的工作）

或

2.最后一个人不能访问BE（FE退出）

I have searched the site and probably came across dozens of posts... I
am somewhat confused about the replies... here is my situation, see if
someone can point me to where to go:

I have splitted up the DB to FE and BE, I want to autocompact BE when:
1. all users exited FE (or if not out by certain time of the day and
it is idle (forgot to logout), force them out of it to do a compact)
or
2. Last person out of accessing the BE (FE exited)

您必须构建自己的程序和审核工具才能执行此操作。

您需要启用Access安全性，或者拥有自己的定制

安全/登录系统。你需要跟踪每个人何时记录

进出 - 检查最后一个退出的人可能是通过FE中隐藏的表格完成的
。当最后一个人退出时，你的隐藏形式可以启动BE紧凑操作。或者你可以留下一个单独的

Access或其他.exe运行并从外面轮询登录/退出表格

FE。


不确定是否强迫某人退出应用。你可以找到关于它的其他

cdma帖子。

You''ll have to build your own programs and auditing tools to do this.
You''ll need to have Access security turned on, or have your own custom
security/login system in place. You''ll need to track when each person logs
in and out - checking for the last person logging out will be probably be
done via a hidden form in the FE. When the last person logs out, your
hidden form can start a BE compact operation. Or you can leave a separate
Access or other .exe running and poll the logged in/out table from outside
the FE.

Not sure about forcing someone out of an app. You can probably find other
cdma posts about it.

提前致谢，

Perry

Thanks in advance,
Perry

不确定强迫某人退出应用程序。你可以找到其他的

Not sure about forcing someone out of an app. You can probably find other

cdma关于它的帖子。

cdma posts about it.

Arvin写了一些东西。 KickEmOut
www.datastrat.com

Arvin wrote something that does that. KickEmOut
www.datastrat.com

谢谢大家的回复。我接受了pietlin的建议并使其工作

相当不错。唯一的情况是，如果有人仍在某种形式，那么，我可能无法强迫他们出局。再次感谢。


佩里

Thank you all for replying. I took pietlin''s advice and make it work
pretty well. The only situation is if someone is still in a form,
then, I may not be able to force them out. Thanks again.

Perry

这篇关于空闲的紧凑BE ...太混乱了！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！