How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2000
来源:互联网 发布:js 怎么对布尔值取反 编辑:程序博客网 时间:2024/05/07 23:15
SUMMARY
By using Microsoft Visual Basic for Applications in Microsoft Access 2000, you can output a list of users who are logged into a database. The code example in this article show you how to do this.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. The user list feature provides a way of determining who is currently connected to a Microsoft Jet database. The list can be obtained via the ADO programming interface and returns the following information for each user: • Name of the computer that the user is using.
• Security name, that is, the user ID.
• Whether or not the user is currently connected to the database. (A user's ID remains in the lock database until the last user disconnects or until the slot is reclaimed for a new user connection.)
• Whether or not the user connection was terminated normally.
• The user list capability can be used in conjunction with the connection control capability to determine which users are still connected, so that they can be asked to disconnect.
The user list capability is also useful in isolating problems with database corruption that is associated with the activities of a specific user.
... ...
阅读全文请点击:How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2000
- How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2000
- How to grant access to SQL logins on a standby database when the guest user is disabled in SQL Serve
- How to synchronize access to a shared resource in a multithreading environment by using Visual C#
- How to Determine if a file is a .Net assembly (in Delphi and C#)
- How To Determine When a Page Is Done Loading in WebBrowser Control
- How to access database using ADO in VB6 - 在 VB6 中用ADO对象如何访问数据库
- 34.A user, who is authenticated externally, logs in to a remote machine and connects to the database
- How to determine if a machine is localhost?
- How to display column values in a single cell in Web Intelligence using Oracle database ?
- How To Determine Table/View Name in a Form
- How to access files in a jar?
- How to read and save Images in a Sql Server Database using ADO.NET and C#
- How to access sqlite database
- How to fix “Firefox is already running” error by Matt Cutts on January 2, 2007 in How to,Linux/Ubu
- How to determine if running on Emulator?
- How to solve the problem : "You have been logged on with a temporary profile"
- SQL: How to get a series of dates in sql using connect by
- HOW TO: Upload a File to a Web Server in ASP.NET by Using Visual Basic .NET
- 不得不看的暗黑2真正编年史
- 全金属外壳的小站开张了!
- 什么是MIS系统
- 怎么学好一门编程语言
- 编程之道
- How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2000
- 对于utf、unicode、GBK、ascII编码的一些浅显了解
- 内存会影响上网
- 评判数据结构
- apache+php+mysql的配置
- [技术娱乐]How to make love
- Eclipse soap写Hello
- Win32 API 绘图与文本输出
- 丘成桐院士HUST演讲全文--谈数学家的志气与操守(