On Wed, 23 May 2007 20:17:00 -0700, Ross
>I am an Access Developer who uses personal custom code to automate the
>production of VBA Code (in MS Access 2003). This code works beautifully with
>XP. It doesn't work with VISTA.
>This will slow my coding speed by 500% and cost me many hundreds of
>keystrokes a day. I may have to return to XP for this reason alone.
>I am using an Access Hotkey to run VBA Code written to produce SQL strings
>automatically using the "SENDKEYS" command to type out the redundant string
>characters. The code locks on the SENDKEYS line with the following Error
>Runtime Error '70':
>My Account type in VISTA is Administrator. How do I get past this error.
>I am 98% sure that ACCESS is not doing this because the same code has run for
>years in XP.
>This is really a big deal for me and I have spent many hours trying to
>Thank you in advance for some advice or a solution.
Apparently, MS decided that Sendkeys is a security risk. Google on
"Sendkeys Vista" to see some of the many discussions on this subject.
For example: http://forums.microsoft.com/msdn/sho...&tf=0&pageid=1
Try turning off UAC for starters (User Accounts screen in Control
Panel). However, this cripples most of the new security features and
may affect how other applications run, so it's not a permanent
The VB and Access forums are the places to look for other solutions,
but my impression is that no one fix works for everyone without side
effects and/or recoding.
Doug M. in NJ