Re: MDB to MDE trouble

Tony Toews [MVP] wrote:
Mike <mikewa@xxxxxxxxxxx> wrote:

With the reference to the reports only mdb the front wont wont convert
to an MDE. Without the reference it will.

AFAIK an MDE can't reference an MDB. An MDB can reference an MDE though.

@Mike - maybe somewhat heavy weight - just an idea:

What you could try is to 'foreign-start' another MDE/MDB from inside a prog mdb/mde accdb VB-app whatever.

Start your second prog-DB using call to
C:\Path2Access\MsAccess.exe C:\whateverpath\anyReport.mde /cmd "call_Report_N_with_Param_M".

You have to parse this startparam while report.mdb is loading and can then decide inside your report.mdb what report with what additional params it should to open. Ok. You need to app.close when closing the report. Clear disadvantage: you cannot control things after launching second Access app.

rob*
.

Relevant Pages

  • Re: Correct Sequence?
    ... a reference to DAO by default. ... When you create a new mdb, ... Microsoft Access MVP ... Now try to create the MDE. ...
    (microsoft.public.access.security)
  • Re: Stephen Lebans Report2PDF
    ... Please select a different Report to Export ... No matter what I throw (Report or existing Snapshot) at it I get this same ... the mde, and as an external library to one of my projects. ... > With reference to Stephen Lebans interesting report to PDF solution found ...
    (microsoft.public.access.reports)
  • Re: Cant update a Report fiels
    ... The logic works in the *.mde version, but not in the *.mdb version. ... I'm able to return the filter string back to the ... >> announce to the report readers that the report is filtered. ...
    (microsoft.public.access.formscoding)
  • Re: Lock / Unlock VBA project
    ... "Alex Dybenko" wrote: ... make MDE? ... library MDB - create ne mdb, import forms/modules from your app, which ... have to make MDE of it and add reference to library MDE in order to make MDE ...
    (microsoft.public.access.modulesdaovba)
  • Re: creating external references
    ... The easiest way to implement this is with a referenced MDE. ... Then 'compile' it into an MDE and set a reference in your other ... deploy the frontends as MDBs (because an MDB will recompile against the new ... DLL, which means that all class GUIDs remain the same after a rebuild. ...
    (microsoft.public.access.modulesdaovba)