Microsoft Access 2003 -- list active users ?

Each of the below MDBs are in folders that has different GROUP permissions which might include 100+ people, but only 2+ people are using the database

How can I START getting a list of all Windows UserNames or Computer HostNames who accesses the files over the next 60 days, so I have results two months from now since I plan to sunset all these old databases after I convert them to newer ASP.net MVC apps ?

  ** 50+ old Access 2003 MDB databases
  ** all in different network folders
finance_teacherAsked:
Who is Participating?
 
Dale FyeCommented:
you might want to check out Total Access Admin from FMS
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Don't know if it's workable for you or not, but one approach would be to remove security for all groups, then see which users complain<g>.

BTW. Total Access Admin may not be able do the job....in order to get a user name, you must be using ULS (User Level Security) aka JET/ACE "workgroup" security on the DB.  You would however be able to get the station name and that might be enough for you.  Also if you wanted to, you could write the same utility easily enough if you wanted to as all it does is read the LDB file.

I think though that you'd come out ahead by just buying it.

Jim.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.