Re: how can I make a runtime version of an access database that us

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Chris O''''Neill wrote:
"Douglas J. Steele" wrote:

Not only is it not possible to compile Office objects into an Access
application (regardless of where you're using the run-time),
distributing files like msoutl.olb is illegal.

I understand that, but is it not possible (and legal) to reference the
msoutl.olb that's already on the user's sytem if they have
Office/Outlook already installed? For instance, I'm developing with
Access XP (ACC10) so the Outlook Object Library is located here:

c:\Program Files\Microsoft Office\Office10\msoutl.olb

I'm assuming that if my application is installed on a system that has
Outlook XP already installed it will run "out of the box" if it finds
msoutl.olb in that subdirectory, right? (Btw, I'll be distributing my
application as an MDE front-end and an MDB back-end, in case that
makes a difference?)

This brings up another question... If the user has Access/Outlook
2003 or 2007 installed, is it possible to programmatically search for
msoutl.olb on their system, change the reference to point at that
library, and have the application run properly? Or, will my
application *only* run on an Access/Outlook XP (2002) system? (Btw,
I'm assuming that my application will *not* run on anything earlier
than Access/Outlook XP, right?)

If the answer to that last question is that it will run so long as the
reference is changed, can someone explain how to programmatically
change the reference? I'm assuming that'd be a DAO routine, right?

Search these groups for "Late Binding". It accomplishes exaclty what you
are describing although not in the manner you describe. It is the only
practical way to use external libraries in a distributed app. Basically it
is a way to utilize external code libraries without setting a reference to
them.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: how can I make a runtime version of an access database that us
    ... application, distributing ... but is it not possible to reference the ... is it possible to programmatically search for msoutl.olb on ... Access/Outlook XP system? ...
    (microsoft.public.access.modulesdaovba)
  • Re: prompts for format in runtime?
    ... the process for distributing runtime checks to see if you're ... >> libraries, but it's something I know nothing about as far as Access goes. ... >>> There's a broken reference in your distributed db. ... >>> HTH ...
    (microsoft.public.access.devtoolkits)
  • Re: how can I make a runtime version of an access database that us
    ... application *only* run on an Access/Outlook XP system? ... reference is changed, can someone explain how to programmatically ... practical way to use external libraries in a distributed app. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Function name not found
    ... Doug Steele, Microsoft Access MVP ... eliminate the need for the reference, ... If you're distributing to customers who are running on a different ... I have this startup methodology that provides a little more ...
    (microsoft.public.access.modulesdaovba)
  • Re: Library Database
    ... That's if you're doing it the way the Help file documents, ... You have to close the database to get rid of the reference. ... I've never had references to these libraries. ... There is a section entitled "Library Database ...
    (comp.databases.ms-access)