We help IT Professionals succeed at work.

Access 2007 Macro hangs in Windows 7 Professional

nulad
nulad asked
on
Our network has been running a Microsoft Office Access 2007 application on Windows XP Professional for a long time without issues.  We have replaced some workstations with Windows 7 Professional (32-bit).

The Access 2007 database application runs okay on the XP machines, but on the Windows 7 machines the macros do not run properly, they hang and freeze the program.  The Access 2007 database files are in trusted locations.

For example a macro's Action is "RunCode", the Function Name is "RunPublicFunction()".  When you run the macro it hangs and freezes Access.  But, if you open up the Module the function is in, and run the code from within the module it runs correctly.

Any ideas?
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016

Commented:
have you checked the UAC (User Account Control) settings on Win 7?
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Are Macros the only way you can run this function...?

If you just try running it from vba via a button click event, what happens?
   Call RunPublicFunction()

JeffCoachman

Author

Commented:
I think the problem turned out to be it did run, but in Windows 7, it does not display an object the code opens (code to open a "save as" dialog box to save the text file to their "My Documents" folder).  So the application appears to be hanging and freezing waiting for the user to finish filling in the "Save as" dialog box.  If you press "Alt" "Tab", the "save as" appears and then the program works as usual.

Any ideas on how to have Windows 7 display the object in front of the menu form?
MIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:

Explore More ContentExplore courses, solutions, and other research materials related to this topic.