nulad
asked on
Access 2007 Macro hangs in Windows 7 Professional
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?
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?
have you checked the UAC (User Account Control) settings on Win 7?
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
If you just try running it from vba via a button click event, what happens?
Call RunPublicFunction()
JeffCoachman
ASKER
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?
Any ideas on how to have Windows 7 display the object in front of the menu form?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.