Last access to MS Access

Posted on 2005-05-13
Last Modified: 2010-04-17
I have been tasked to find out how many of my users (1500) use MS Access from the Office Suite.   We are considering removing the app from our image.   Is there a way to find out remotely, without user intervention, a last accessed date for Access only?  Please help EE, you're my only hope!  Thanks!
Question by:TICITG
    LVL 65

    Accepted Solution

    No idea.  However, Access Runtime can be distributed royalty-free.

    Author Comment

    Jim thanks for your participation points in this, however, that was not very helpful.  
    LVL 24

    Assisted Solution

    I dunno either. First thought is to keep it, for it is rather useful, and with 1500 users, it is really likely they do.

    Second thought, is that a dark cloud for access (to me) is that it changes the dates associated with file access, whether or not there were any changes. The silver lining, for you, could be, that simply using explorer can help you identify which databases are being used, whether or not anyone is making any changes.

    Take the ones being actually used, then look for an owner, and ask them if the these files have any value, or how valuable they are to the business. Then look at the cost, how much the licensing is really putting you back.

    It should not be about user opinion, for access (aside from real developers), it should be about whether the activities themselves have any merit it the business.

    Personally, I think it does, and do not need the numbers of users, or frequency of database lookups to figure that out. It is more about who gets to change what data, and what other forms of data you have, from Oracle to Excel.

    Consider, for example, situation of several collections pulled into an access base, then, it gets reformatted and exported to some other format, such as excel. So the hit rates will likely be higher for excel than access, but only because the data has been moved from access to excel already. Without Access, you'd then also lose all those Excel uses --- not good.

    But I'd agree that you should not have to pay a lot for only a few developers. Since it is part of a suite, you should be able to get a decent price. I think bigger issue is powerpoint, which can also be more costly, but has little need for use of too many in the organization when Word is also getting used well. How much of your excel use is review of data from powerpoint?
    LVL 2

    Expert Comment

    you don't have a running MS Systems Management Server 2003? ...because then it would be very simple to get this kind of data...

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    zeroMAx challenge 20 66
    array11 challenge 16 40
    WMI, model #, retrieving information 10 59
    python question 5 42
    This article will show, step by step, how to integrate R code into a R Sweave document
    In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now