MDB and connected users/computers

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hello!

Have a mdb file, to which different computers have access via DAO. Now, I
want to know how many computers/users access the mdb and maybe the
computer/username. Is there any solution?

Thanks

Tim
 
Tim said:
Have a mdb file, to which different computers have access via DAO. Now, I
want to know how many computers/users access the mdb and maybe the
computer/username. Is there any solution?
Click to expand...

No.

You can record this information in the FE but not the BE. Also you
have no idea if someone has copied the database and taken it home with
them.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Sorry, maybe some more explanation:

I need to know whether any other user with DAO.Opendatabase("xyz.mdb")
from another application access the mdb. In the ldb, I see the connected
users, but I saw, that a disconnected users not immediatly disappears from
the ldb.

Tim
 
Tim said:
I need to know whether any other user with DAO.Opendatabase("xyz.mdb")
from another application access the mdb. In the ldb, I see the connected
users, but I saw, that a disconnected users not immediatly disappears from
the ldb.
Click to expand...

No you can't record who connects in the BE via any means other than
code in the FE. Someone who creates their own FE and links to tables
in your BE can't be recorded.

Products such as SQL Server likely do support this functionality.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
If you have control over the Front End - as in your the creator of it - Yes.
However, Access does not have any means of intrinsically knowing when an
external link to the tables in a database has been established. Hence, I can
create hundreds of Front Ends that capture all of the relevant information,
but if Joe Schmo creates a DB and links to the backend, there's no way of
knowing that that's been done. Access is completely bind when it comes to
external applications/files/whatever (you want to call them) linking in.
 
Back
Top