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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
you might want to check out Total Access Admin from FMS
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.