Microsoft Office Library Reference

What would happen if an Access97 database had a reference to Microsoft
Office 10 library (but only used Access97 stuff) and it was run on a machine
that only had Access97 and correspondingly only had Microsoft Office 8
library? Would Access97 be smart enough to go to the Microsoft Office 8
library when it needed to?

Thanks,

Steve

re: Microsoft Office Library Reference

On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <nospam@nospam.spam> wrote:

Typically yes. That's the power of OLE for you.
-Tom.

[color=blue]
>What would happen if an Access97 database had a reference to Microsoft
>Office 10 library (but only used Access97 stuff) and it was run on a machine
>that only had Access97 and correspondingly only had Microsoft Office 8
>library? Would Access97 be smart enough to go to the Microsoft Office 8
>library when it needed to?
>
>Thanks,
>
>Steve
>[/color]

re: Microsoft Office Library Reference

Tom,

Thanks! What exactly happens when Access97 sees a reference from another
version?

Steve


"Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
news:l3rm01hg7fs0f6sn9pl7vilu8vt95ej8bb@4ax.com...[color=blue]
> On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <nospam@nospam.spam> wrote:
>
> Typically yes. That's the power of OLE for you.
> -Tom.
>
>[color=green]
> >What would happen if an Access97 database had a reference to Microsoft
> >Office 10 library (but only used Access97 stuff) and it was run on a[/color][/color]
machine[color=blue][color=green]
> >that only had Access97 and correspondingly only had Microsoft Office 8
> >library? Would Access97 be smart enough to go to the Microsoft Office 8
> >library when it needed to?
> >
> >Thanks,
> >
> >Steve
> >[/color]
>[/color]

re: Microsoft Office Library Reference

That's not been my experience.
If an Access 97 database has a reference to Office 8, it will run happily on
a machine with Office 10, but I haven't had any success in the opposite
scenario.
In such cases, I've had good success using late binding.

hth
- Turtle

"Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
news:l3rm01hg7fs0f6sn9pl7vilu8vt95ej8bb@4ax.com...[color=blue]
> On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <nospam@nospam.spam> wrote:
>
> Typically yes. That's the power of OLE for you.
> -Tom.
>
>[color=green]
> >What would happen if an Access97 database had a reference to Microsoft
> >Office 10 library (but only used Access97 stuff) and it was run on a[/color][/color]
machine[color=blue][color=green]
> >that only had Access97 and correspondingly only had Microsoft Office 8
> >library? Would Access97 be smart enough to go to the Microsoft Office 8
> >library when it needed to?
> >
> >Thanks,
> >
> >Steve
> >[/color]
>[/color]

re: Microsoft Office Library Reference

Tom,

If it is not an imposition, would you take a look at my previous post
"Commandbars Controls Collection" (back 8 posts) and see if you have any
idea why the Dim statements work in one place but not the other. Are you
saying here that if I set a reference to Microsoft Office 10 library (but
only used Access97 stuff) and dimmed Cbr as CommandBar and dimmed Ctl as
CommandBarControl that the database would run on a machine with only
Access97 (Microsoft Office 10 library )?

Steve


"Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
news:l3rm01hg7fs0f6sn9pl7vilu8vt95ej8bb@4ax.com...[color=blue]
> On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <nospam@nospam.spam> wrote:
>
> Typically yes. That's the power of OLE for you.
> -Tom.
>
>[color=green]
> >What would happen if an Access97 database had a reference to Microsoft
> >Office 10 library (but only used Access97 stuff) and it was run on a[/color][/color]
machine[color=blue][color=green]
> >that only had Access97 and correspondingly only had Microsoft Office 8
> >library? Would Access97 be smart enough to go to the Microsoft Office 8
> >library when it needed to?
> >
> >Thanks,
> >
> >Steve
> >[/color]
>[/color]

re: Microsoft Office Library Reference

Turtle,

If it is not an imposition, would you take a look at my previous post
"Commandbars Controls Collection" (back 8 posts) and see if you have any
idea why the Dim statements work in one place but not the other. I'm using
late binding. Are you
saying here that if I set a reference to Microsoft Office 10 library (but
only used Access97 stuff) and dimmed Cbr as CommandBar and dimmed Ctl as
CommandBarControl that the database WOULD NOT run on a machine with only
Access97 (Microsoft Office 10 library )?

Thanks,

Steve

"MacDermott" <macdermott@nospam.com> wrote in message
news:J6KOd.11770$wK.5793@newsread3.news.atl.earthl ink.net...[color=blue]
> That's not been my experience.
> If an Access 97 database has a reference to Office 8, it will run happily[/color]
on[color=blue]
> a machine with Office 10, but I haven't had any success in the opposite
> scenario.
> In such cases, I've had good success using late binding.
>
> hth
> - Turtle
>
> "Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
> news:l3rm01hg7fs0f6sn9pl7vilu8vt95ej8bb@4ax.com...[color=green]
> > On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <nospam@nospam.spam> wrote:
> >
> > Typically yes. That's the power of OLE for you.
> > -Tom.
> >
> >[color=darkred]
> > >What would happen if an Access97 database had a reference to Microsoft
> > >Office 10 library (but only used Access97 stuff) and it was run on a[/color][/color]
> machine[color=green][color=darkred]
> > >that only had Access97 and correspondingly only had Microsoft Office 8
> > >library? Would Access97 be smart enough to go to the Microsoft Office 8
> > >library when it needed to?
> > >
> > >Thanks,
> > >
> > >Steve
> > >[/color]
> >[/color]
>
>[/color]

re: Microsoft Office Library Reference

I would not expect a database with a reference to Microsoft Office 10
library to run on a machine with only Microsoft Office 8 library installed.

"Late binding" means more than just declaring a variable as Object.
If you're using late binding, you remove the reference to Microsoft Office
from your database's references entirely. You'd then use a syntax like
this:
Set cbr=CreateObject("Office.CommandBar") (WARNING: AIR CODE)
to instantiate your object.
Otherwise, you're not really using late binding.

HTH
- Turtle

"Steve" <nospam@nospam.spam> wrote in message
news:kvKOd.11780$wK.52@newsread3.news.atl.earthlin k.net...[color=blue]
> Turtle,
>
> If it is not an imposition, would you take a look at my previous post
> "Commandbars Controls Collection" (back 8 posts) and see if you have any
> idea why the Dim statements work in one place but not the other. I'm using
> late binding. Are you
> saying here that if I set a reference to Microsoft Office 10 library (but
> only used Access97 stuff) and dimmed Cbr as CommandBar and dimmed Ctl as
> CommandBarControl that the database WOULD NOT run on a machine with only
> Access97 (Microsoft Office 10 library )?
>
> Thanks,
>
> Steve
>
> "MacDermott" <macdermott@nospam.com> wrote in message
> news:J6KOd.11770$wK.5793@newsread3.news.atl.earthl ink.net...[color=green]
> > That's not been my experience.
> > If an Access 97 database has a reference to Office 8, it will run[/color][/color]
happily[color=blue]
> on[color=green]
> > a machine with Office 10, but I haven't had any success in the opposite
> > scenario.
> > In such cases, I've had good success using late binding.
> >
> > hth
> > - Turtle
> >
> > "Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
> > news:l3rm01hg7fs0f6sn9pl7vilu8vt95ej8bb@4ax.com...[color=darkred]
> > > On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <nospam@nospam.spam> wrote:
> > >
> > > Typically yes. That's the power of OLE for you.
> > > -Tom.
> > >
> > >
> > > >What would happen if an Access97 database had a reference to[/color][/color][/color]
Microsoft[color=blue][color=green][color=darkred]
> > > >Office 10 library (but only used Access97 stuff) and it was run on a[/color]
> > machine[color=darkred]
> > > >that only had Access97 and correspondingly only had Microsoft Office[/color][/color][/color]
8[color=blue][color=green][color=darkred]
> > > >library? Would Access97 be smart enough to go to the Microsoft Office[/color][/color][/color]
8[color=blue][color=green][color=darkred]
> > > >library when it needed to?
> > > >
> > > >Thanks,
> > > >
> > > >Steve
> > > >
> > >[/color]
> >
> >[/color]
>
>[/color]