Error when sending a MDE file??

[AJ]

I am trying to send an MDE file via email or using a website like "YOU SEnd
IT". I have tried both zipped and unzipped. My issue is that when I run it on
the new pc, I get an error
"expression on click you entered as the event property setting produced the
following error: there was a problem accessing a property or method of the
OLE object"
I am novice access user and would jsut like others to be able to use this
application, can someone please help.
THANK YOU IN ADVANCE!

 

[PeterM]

I'd first check all of the options on the new PC trying to run the MDE file
and ensure that the same options are selected as the PC where the .MDE was
created. Also, ensure the security levels are compatable between the two
PC's.

 

[Tony Toews [MVP]]

I am trying to send an MDE file via email or using a website like "YOU SEnd
IT". I have tried both zipped and unzipped. My issue is that when I run it on
the new pc, I get an error
"expression on click you entered as the event property setting produced the
following error: there was a problem accessing a property or method of the
OLE object"

This sounds like a references error which you must fix on the MDB from
which you made the MDE.

Do you have any references besides the basic three? Are you sure you
need them? Write down the path and name of the extra ones (or put the
following code in a module and execute the code), delete from the
references list and Compile and Save All. Keep any necessary
references and ensure they are distributed to the target system.

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " " & ref.FullPath & " " & ref.Major &
"." & ref.Minor
Next ref

For a very detailed page on reference problems see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.

The Access 97 default references are:
Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.5x Object Library

The Access 2000 default references are:
Visual Basic for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
or
Microsoft DAO 3.6 Object Library

The Access 2002 default references when the MDB is created in Access
2000 format are:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library

The Access 2002 default references when the MDB is created in Access
2002 format are:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.5 Library.

The Access 2003 default references when the MDB is in A2000 format are
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library

The Access 2003 default references when the MDB is in A2002/A2003
format are
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.5 Library

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/