Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

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

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.
0
archerdcrosley
Asked:
archerdcrosley
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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).
HTH,
JimD.
0
 
archerdcrosleyAuthor Commented:
I agree, but I need to send keys function in this case to automate ms paint to do a few things.  thx.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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.
JimD.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now