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