Runtime switch problem

[Galaxiom]

MDB database runs on my PC in Access 2007 in either full or runtime mode (using /runtime switch).
Runs on PCs with only Runtime 2007 installed.
Runs in full mode on PCs with Access 2007 installed.

Won't run ("Sorry but had to close" message) using Access 2007 with runtime switch on other PCs.

Access on XP Pro, both fully patched.

Any suggestions welcome.

 

[Rabbie]

Have you checked VBA references on PCs where you have problems?

 

[ghudson]

You need to ensure you have proper error trapping for all of your VBA routines, especially when using the runtime version of access. Then your users can provide you with the error number and message if they encounter a runtime error with your database.

Private Sub Form_Open(cancel As Integer)
On Error GoTo Err_Form_Open

   InsideHeight = 3855
   InsideWidth = 7695
 
Exit_Form_Open:
    Exit Sub

Err_Form_Open:
    MsgBox Err.Number & " - " & Err.Description, vbCritical, "Form_Open()"
    Resume Exit_Form_Open

End Sub

 

[Galaxiom]

Found the problem.

Classic Menus for Office 2007 V 3.91
www.addintools.com

Crashes Access when opening a database in runtime mode.

 

[ghudson]

Cannot imagine a reason to want to bring back the classic menus into Office 2007.

IMO: Most developers remove the default menus/ribbon and built their own or only use VBA via command buttons to enable the users to perform the actions only the developer wants the user to be able to do within their custom applications.

 

[boblarson]

You need to ensure you have proper error trapping for all of your VBA routines, especially when using the runtime version of access.

Sort of true, but if you compile to an MDE / ACCDE it will not crash on unhandled errors (Access MVP Albert Kallal taught me that one).

 

[Galaxiom]

Cannot imagine a reason to want to bring back the classic menus into Office 2007.

It makes the transition painless particularly for busy managers who use Excel all day long. The addin simply appends another ribbon with the old menus.

It saves a lot of frustration and wasted time when they can't find someting in the new ribbons. From an IT support and management productivity point of view it is certainly worth the paltry licence cost.

Eventually they become familiar the new interface.

BTW The developer replied to my bug report on the same day and sent me a licence key for the latest version.