Deployment problems

[blue weasle]

Greetings all,

I have a problem with my DB once it gets deployed. I include the Access runtime using the Deployment Wizard but when we install it and open the DB it give us "May contain harmfull Macron. Please install Jet engine 8.0" Then it continues on to say "the application may contain harmful macros do you wish to continue?" we say yes but still no luck. We updated the jet engine but no luck there either. The DB opens but some of the code that brings up pictures on the "on load" event, isn't working. It works on computers that have access installed but not on the Run-time installations. Any suggestions. You guys have helped so much in the past to get me this far in my Access career and this one needs answered quick.

Thanks,

Eric

 

[blue weasle]

Please Help!!!!

I'm pulling my hair out here. (what little's left) and i still can't figure this out. I've registerd .dll's, installed jet services, changed my code but this still isn't working. I'm on the edge here and this is really throwing me a loop. The thing is, this is the simplest app I've ever written and now I can't get it to install on a runtime license. There's maybe a total of 40 lines of code. PLEASE ANYONE HEEEEEELLLLPPPP!!!

 

[WindSailor]

Reset your macro level to low before you make your .mde and see if that helps.
There are multiple examples here to show you how.
In the wizard there are mulitple tests for sandbox mode, conflicts etc if you have Access 2003, try running those.
Also I would put in error traping code on your "on load" event of your form to see what fails.

 

[blue weasle]

still no luck

Thanks for the reply Rick,

I went through the process you suggested once before and then tried it again after reading your suggestion to see if I missed anything, but to no avail. Everything works on computers with Access already installed but craps out on computers with the run-time. It's a very simple chunk of code and I'm not sure what's going on. The error I get is "can't find msdatobj.dll". I've installed dao and ms jet on my test computer but nothin'.

Here's the code for the form:

Private Sub Form_Current()
On Error GoTo Err_Form_Current

If Not IsNull([Owner]) Then
Forms!frmViewProperty![AerialPhoto].Picture = "C:\Program Files\LandownerDB\photo_images\" & Me.[Owner] & ".png"
SysCmd acSysCmdSetStatus, "Image: 'C:\Program Files\LandownerDB\photo_images\" & Me.[Owner] & ".png" '."
Forms!frmViewProperty![TopoMap].Picture = "C:\Program Files\LandownerDB\Topo_images\" & Me.[Owner] & ".png"
SysCmd acSysCmdSetStatus, "Image: 'C:\Program Files\LandownerDB\topo_images\" & Me.[Owner] & ".png" '."
Else
Forms!frmViewProperty![AerialPhoto].Picture = ""
SysCmd acSysCmdClearStatus
Forms!frmViewProperty![TopoMap].Picture = ""
SysCmd acSysCmdClearStatus
End If


'AerialPhoto.Picture = "C:\Program Files\LandownerDB\photo_images\" & Me.[Owner] & ".png"
'TopoMap.Picture = "C:\Program Files\LandownerDB\Topo_images\" & Me.[Owner] & ".png"


Me.lRecordXofY2 = "Record " & [CurrentRecord] & " of " & IIf([NewRecord], [CurrentRecord], DCount("*", "Jackson_Export"))

UpdateRecordCount

Exit_Form_Current:
Exit Sub

Err_Form_Current:
MsgBox "The current record does not have a map associated with it." & vbCrLf & _
"Please contact MEGIS to solve this problem", , "No maps for this record!"
Resume Exit_Form_Current
End Sub

It craps on the image lines. Everything else works fine. This is a very simple DB that only has 1 form and 1 table, that's all! As you browse through a list of Landowners, the 'on load' event finds the corrisponding map and displays it below the landowner name. That's it, nothing else.

What am I missing here?

Thanks again,

Eric

 

[ghudson]

There must be a missing refernce that you are using in your db but it is not included with the runtime installation.

Also, your error routine is weak for it does not display the error number and description.

 

[blue weasle]

ghudson,

Thanks, and I found the missing reference and registered it, then I ran into an image type problem and I'm currently fixing that. Due to the simple nature of th DB I didn't write alot of code until now. Like you mentioned, I went back and added the code and quickly located my error. I think I finally got this problem uder control. It was a first for me to deploy on a computer not running Access already.

Thanks,

Eric