Hello, I would like to run a geoprocessing model within Access (part of a series of tasks). As a test, I created a basic command button that called the event procedure shown below (essentially pulled from here: http://support.esri.com/en/knowledgebase/techarticles/detail/31110), however, it crashes and shuts down my database. The very simple test model runs correctly within ArcCatalog 10.Help?
Private Sub gpModelName_Click()
Dim pGP As Object
Set pGP = CreateObject("esriGeoprocessing.GPDispatch.1")
On Error GoTo EH
MsgBox pGP.GetMessages(), vbOKOnly, "Error. Please run manually: <b>ModelName</b>"