Access 2007 crashes after move to Vista

[Chris L]

Hi all,

My company is currently rolling out Vista and my 2003 DB keeps crashing if I open a form with several subforms.

Has anyone had similar problems? I searched serveral forums but couldn't find an answer. If anyone knows whether certain form commands, especially regarding recordsource etc are not compatible in Access 2007, it would be much appreciated.

Thanks
Chris

 

[boblarson]

2007 should work fine with 2003. Have you

1. Set MSAccess.exe to run as Administrator

2. Added the location of the mdb file to the Trusted Locations

 

[Chris L]

Hi Bob,

Thanks for your instant reply!

I have tried option a and enabled all Macros but it still crashes.

It looks like it's crashing when I open a certain form and close another one. When I debug the program it does not crash until it exits the close form function and if I stop the macro before it hits the following code, it doesn't crash.


Private Sub Form_Close()
On Error GoTo Err_Form_Close

Dim col1 As VBA.Collection
Dim args As Integer

args = instID

'open the installation form
DoCmd.OpenForm "main_app_install", acNormal, , , , acWindowNormal, args

'settings for the mousewheele
clsMouseWheel.SubClassUnHookForm
Set clsMouseWheel.Form = Nothing
Set clsMouseWheel = Nothing

Exit Sub
Err_Form_Close:
ErrorMsg "sub", "form", "Form_Close", Me.Name, Err.Number, Err.description
End Sub



Thanks again for the help
Chris

 

[boblarson]

It probably has to do with the mousewheel code and you might want to disable that and see if that helps.

 

[Chris L]

Hey mate,

Thanks heaps. That worked!!!

Cheers
Chris