Microsoft Office Library Reference

[Steve]

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

[Tom van Stiphout]

On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <no****@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 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

[Steve]

Tom,

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

Steve
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:l3********************************@4ax.com...

On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <no****@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 Microsoft
Office 10 library (but only used Access97 stuff) and it was run on a machinethat 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

[MacDermott]

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*************@cox.net> wrote in message
news:l3********************************@4ax.com...

On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <no****@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 Microsoft
Office 10 library (but only used Access97 stuff) and it was run on a machinethat 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

[Steve]

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*************@cox.net> wrote in message
news:l3********************************@4ax.com...

On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <no****@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 Microsoft
Office 10 library (but only used Access97 stuff) and it was run on a machinethat 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

[Steve]

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" <ma********@nospam.com> wrote in message
news:J6*****************@newsread3.news.atl.earthl ink.net...

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*************@cox.net> wrote in message
news:l3********************************@4ax.com...

On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <no****@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 Microsoft
Office 10 library (but only used Access97 stuff) and it was run on a machinethat 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

[MacDermott]

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" <no****@nospam.spam> wrote in message
news:kv***************@newsread3.news.atl.earthlin k.net...

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" <ma********@nospam.com> wrote in message
news:J6*****************@newsread3.news.atl.earthl ink.net...

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*************@cox.net> wrote in message
news:l3********************************@4ax.com...

On Thu, 10 Feb 2005 14:07:44 GMT, "Steve" <no****@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 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
>