By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,651 Members | 1,551 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,651 IT Pros & Developers. It's quick & easy.

Microsoft Office Library Reference

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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


Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

P: n/a
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

Nov 13 '05 #4

P: n/a
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

Nov 13 '05 #5

P: n/a
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


Nov 13 '05 #6

P: n/a
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
>



Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.