Re: Opening report in another db



--
Bob Darlington
Brisbane
"Sky" <s.young @ stanley associates . com> wrote in message
news:fTeFk.301$yI6.104@xxxxxxxxxxxxxxxxxxxxxxx
"dpcman01" <bob@xxxxxxxxxxxxx> wrote in message
news:48e550dc$0$4452$afc38c87@xxxxxxxxxxxxxxxxxxxxxxx
Thanks Lyle,
I'd already been down that track, but couldn't get it to work from
distributed Access 2002 mde's.
The problem was finding the path to the reference when installed on
different user systems, since the reference can't be changed in an mde at
runtime.
Some users have stand-alone PC's and others are using Win2003 Server with
TS.
Do you have any ideas to overcome this reference addressing issue?
--
Bob Darlington
Brisbane

If you install the referenced library database .mde file in the same
folder as the front-end application .mde, then the front-end will find and
reference the library database automatically, even if it was compiled in a
different path on the developer's computer. I have used this feature in
both Access 2000 and 2003. I would expect it works the same way in Access
2002.

Another option is to create the RefLibPaths registry entry, but that has
proved more troublesome for me, especially if you install more than one
application on the same customer computer.

- Steve


Steve,
I followed your advice and loaded the referenced mde in the same folder as
the front end mde, but get an error message indicating that there is a
missing reference (ie "The expression you entered has a function that ...
can't find" .
If I load the front end as an mdb, there's no problem, but my distributed
app needs to be an mde.
I might need to look at your second suggestion with RefLibPaths, but here
again, couldn't I expect to have the same problem from an mde front end?


.

Relevant Pages

  • Re: Opening report in another db
    ... If you install the referenced library database .mde file in the same ... folder as the front-end application .mde, ... that first and complain about the reference. ... front-end copy .mdb to the obscure library .mde, and finally compiling the ...
    (comp.databases.ms-access)
  • 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)
  • Re: Early vs Late Binding - Final Exam
    ... Checking for 'isbroken' at startup is worthless in an mde: ... > I want to reference some word constants such as Word.Range, ... >> If you have heard that developer's recommend late binding, ... > I got into this mess originally because of the broken/missing libraries. ...
    (microsoft.public.access.externaldata)
  • Re: MDB referencing MDE Database
    ... Do I need to change any of my VBA code for referencing?? ... declare Global Arrays and I also reference reports and forms in my VBA code ... Make the mde from the part with just Modules and Macros???? ... a mde database. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: MDE in Access 2003
    ... and in many cases the mde will happily handle a later reference (the ... but I'm not sure if Web Components is one of them. ... >> Access 2002, and create an MDE file, those users still in Office XP cannot ...
    (microsoft.public.access.conversion)
Loading