How do I add MS Acess Utility Add-in to MS Access on Windows 2003 Server

Posted on 2009-04-22
Last Modified: 2013-11-27
I'm trying to use SendKeys in MS Access.  I used to be able to do this when  my program was on one computer only.  When we began using Windows 2003 Server, I noticed that I couldn't program in the SendKeys function.  I keep getting an error message instructing me to install the MS Access Utility Add-in.  I re-installed the MS Access (2003), but I still get the error message.  Now, on the re-installation, there was no box that I could select that specifically stated MS Utility Add-in.  I could only ask to install the customized features.  Any suggestions?

Additional info:  We are using a database with the backend being MS SQL Server and the front end 2003 MS Access.
Question by:archerdcrosley
    LVL 56

    Accepted Solution

    I'm not 100%  what you are referring to, but the MS Utility add-in is a add-in library that came with Access 97.  It's not part of A2003 in the same format.  You must download it from Microsoft's web site and install it manually as it is not part of an A2003 install.
    As far as the utility itself, you can use it in your app, but it's always best to avoid calls into any of the utility functions provided with Access.
    and Sendkeys should be avoided at all costs.  If a user clicks on anything (the focus shifts somewhere else) before or during the sendkeys executing, you can have anything from nothing at all happening to all sort of things opening and closing (whatever window has the focus will receive the keystrokes and not your app).

    Author Closing Comment

    I agree, but I need to send keys function in this case to automate ms paint to do a few things.  thx.
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    BTW, it may be that you've just been carrying the reference along and don't really use anything in that lib.  Go to too/references and try un-checking it and see if the app still compiles.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    VB Access SQL question 2 17
    Calulated Field in MSAccess 11 15
    Order by 8 20
    Microsoft Access combo box help 2 14
    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    728 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

    19 Experts available now in Live!

    Get 1:1 Help Now