如何确定是否有人登录BE数据库？ [英] How do you determine if anyone is logged onto a BE database?

问题描述

我在网络上有一个系统，想确定目前是否有人将b $ b连接到后端文件。


一个有趣的转折点是我注意到有些用户可以连接

（前端以第一种形式打开），即使这链接到后端文件

，没有创建ldb文件。


这是我知道什么时候可以安全地压缩后端文件而不用

来确保每个人都是已登出。用户级别的安全性在

的地方。


谢谢

Jeff

I have a system on a network and want to determine if anyone is currently
connected to the back-end files.

An interesting twist is that I have noticed that some users can be connected
(have the front end open at the first form) and even though this links to
the back-end files, there are no ldb files created.

This is so I know when it is safe to compact the back-end files without
going round to make sure everyone is logged off. User level security is in
place.

Thanks
Jeff

推荐答案

杰夫，

我不是专家，但我的理解是你可以拥有前端op

并且它不会影响后端如果打开的表单没有绑定到后端表中的
。我很确定如果后端没有lbd文件

，则没有人会连接到它。


Mark

" Jeff" < JE ************ @ asken.com.au>在消息中写道

news：43 ********************** @ per-qv1-newsreader-01.iinet.net.au ...

Jeff,
I''m no expert but my understanding is that you can have the frontend op
and it will not affect the backend if the forms that are open are not bound
to a table from the backend. I''m pretty sure that if there is no lbd file
present for the backend, no-one will be connected to it.

Mark
"Jeff" <je************@asken.com.au> wrote in message
news:43**********************@per-qv1-newsreader-01.iinet.net.au...

我在网络上有一个系统，想确定当前是否有人连接到后端文件。

一个有趣的转折点是我注意到有些用户可以连接（前端以第一种形式打开），即使这个链接到后端文件，也没有创建ldb文件。 />
这就是我知道什么时候可以安全地压缩后端文件，而不是确保每个人都注销。用户级安全性在
位置。

谢谢
杰夫

I have a system on a network and want to determine if anyone is currently
connected to the back-end files.

An interesting twist is that I have noticed that some users can be
connected (have the front end open at the first form) and even though this
links to the back-end files, there are no ldb files created.

This is so I know when it is safe to compact the back-end files without
going round to make sure everyone is logged off. User level security is in
place.

Thanks
Jeff

为什么不尝试紧凑它&处理错误？如果它有效，那就是b $ b工作了。如果它没有，你可以打印一个量身定制的信息&然后再试一次

以后。


HTH，

TC

Why not just try to compact it & handle the error? If it works, it
worked. If it didn''t, you can print a tailored message & then try again
later.

HTH,
TC

以前用于工作（访问97天）。


私有函数CanBeOpenedExclusively（ByVal FullPath As String）As

Boolean

Dim d As数据库

Dim p As PrivDBEngine

设置p =新PrivDBEngine

On Error Resume Next

设置d = p（0）.OpenDatabase（FullPath，True）

CanBeOpenedExclusively = Not（d Is Nothing）

p（0）.Close

设置d =无任何

设置p =无结果

结束功能

This used to work in the olden (access 97 days).

Private Function CanBeOpenedExclusively(ByVal FullPath As String) As
Boolean
Dim d As Database
Dim p As PrivDBEngine
Set p = New PrivDBEngine
On Error Resume Next
Set d = p(0).OpenDatabase(FullPath, True)
CanBeOpenedExclusively = Not (d Is Nothing)
p(0).Close
Set d = Nothing
Set p = Nothing
End Function

这篇关于如何确定是否有人登录BE数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！