Problems with custom toolbars & switchboard after converting to mde

  • Thread starter Thread starter Silvester
  • Start date Start date
S

Silvester

Hi,

I have a A2000 mdb with a switchboard and custom toolbars. The buttons on
the toolbars call vba functions like =Open_Help()

When I converted this mdb to mde, clicking on the custom toolbar and
switchboard generates error "Function Name cannot be found"

How do I resolve this problem ??

Thanks for any help
 
Are you saying that on the same pc that the mdb works, the mde does not
work?

For sure those menu bars do use the expression service. In access97 if you
moved the mde to a differtn pc and the version of jet was slightly
different, then the expression service could break.

However, I have not experienced this same breakage problem in a2000.
However, it is possible that you do have a number of references in the mde
file that function on your development pc, but when you move the mde to
another pc, perhaps some of those other applications that you reference are
missing? (that could certainly explain the broken reference problem).

If you are having this problem on the development pc where you convert the
mdb to mde, and it does not work (on the same pc), then that very strange
indeed.

Do all of the menu options stop working, or just some? I am at a loss to
come up with what the problem here is, but perhaps there is some other
detail you are not mentioning?

Are you using any references to other mde files here?
 
Thank you for your help in this matter. I need to clarify...

* I have secured the A2000 mdb fe and be using the same custom workgroup
file. I do NOT distribute this file with the mdb.
* The mdb and consequent mde work perfectly on the development machine.
* I do not reference any other mde
* I follow Peter Walker's system of referencing as found at
http://www.papwalker.com.au/dllhell/index.html . This method works perfectly
when I distribute the mdb and there are no broken references.
* All the buttons on the custom toolbar and switchboard stopped working in
the distributed mde but autoexec macro runs perfectly.

Do you have any suggestions ?
 
I have removed reference to
a.. Microsoft ActiveX Data Objects 2.1 Library
in the mdb and its worked fine when distributed. Could this cause the mde
problem.
 
Yes, very likely as mentioned, you thus do have a reference problem.

If that same ado library is not present on the target pc, and you have a
reference to it, then bingo..you are in trouble.

Of course, the "instant" hint here is that the expression service breaks.
The expression service is something that interprets expressions (things you
put in a text box, or Eval function, or things that get run from menu bars).
These expressions are not resolved at compile time, but only at run time.
 
I am still having the same problem. I ensured that latest mdac and ado dlls
are included and referenced by the mdb. The consequent mde works fine on
development machine but toolbars and switchboard buttons are crippled
generating the same error.

How would I check for broken references in an mde ??

Would appreciate any suggestions.
 
Back
Top