Who's in my database?

  • Thread starter Thread starter bruce
  • Start date Start date
B

bruce

I want to create a function that will allow me to see who
is in a shared database at any given time.

I've read and copied the code from the KB Article:
"HOW TO: Check Who Logged into Database with Jet
UserRoster in Access 2000", and modified
the "C:\Northwind.mdb" entries to my database path and
name.

When I run this, I get the error that says I do not have
the necessary permissions to use the database, although I
am the owner with all rights/permissions, etc...

I would also like to allow certain other users (who are
not the owner) to be able to see who else is in the
database..

So how do I do it?

Thanx Much
 
It is not perfect, but I wrote code to write a record when a user opens the
database to a particular table. The code is tied to a form that opens
automatically and then hides itself. There is also code in the form's close
event that goes and finds the record in the table and adds a date and time
logged off.

I created a separate form that displays all the records with no logoff time.

I had problems with this not always updating when a user logged off, so I
quit using it, but it did work about 98% of the time and might serve your
purpose. I'm pretty sure I found the sample code on one of the MVP
websites. You might search there.

I ran into trouble with that UserRoster program and never could get it to
work for me.

In short, I gave up and decided I really did not care who was logged on, as
long as I had code in place to log them off at will.

Hope that help,

Rick B

I want to create a function that will allow me to see who
is in a shared database at any given time.

I've read and copied the code from the KB Article:
"HOW TO: Check Who Logged into Database with Jet
UserRoster in Access 2000", and modified
the "C:\Northwind.mdb" entries to my database path and
name.

When I run this, I get the error that says I do not have
the necessary permissions to use the database, although I
am the owner with all rights/permissions, etc...

I would also like to allow certain other users (who are
not the owner) to be able to see who else is in the
database..

So how do I do it?

Thanx Much
 
Back
Top