Who Connect to database

  • Thread starter Thread starter Vincent Choy
  • Start date Start date
V

Vincent Choy

Is there any method to detect who connect to the database (Access) in
VB/Delphi/MFC?



Vincent
 
Not after the fact. If you are using VB then there are a couple of
methods that you could apply to the front-end. You are able to use
system login information to log for tracability. I'm assuming that you
currently are not using a front-end to the access database.
 
Vincent Choy said:
Is there any method to detect who connect to the database (Access) in
VB/Delphi/MFC?



Vincent
Click to expand...

The [DBName].LDB file contains information on who is *currently* logged in
to the database, as well as other useful information. There are a couple of
articles on MSDN which describe the structure of the file. there is also a
utility (LDBView) which will display this information, and a DLL
(MSLDBUSR.DLL) which provides this functionality programatically. Here is a
link to an article describing the layout of the LDB file and usage examples
for the DLL. Unfortunately it is rather long so it will probably wrap:

http://msdn.microsoft.com/library/d...oftAccessUnderstandingMicrosoftJetLocking.asp
 
Back
Top