Link to home
Start Free TrialLog in
Avatar of finance_teacher
finance_teacher

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.