I wrote a simple App in Access 2003 but used the 2000 file format. The
one module Requires reference to Microsoft Office 11.0 Object Library.
However, the person I have the code to has Office 2003 but only
Microsoft Office 9.0 Object Library.
Are they not backward compatible? Is there something the user can do
to update this to Office 11? 9 2098
You must use the correct library for the particular version of Access you
use. Access 2000 is Office 9. Access 2003 is Office 11.
The usual workaround is to use late binding. That is, omit the Office
reference all together, and declare the affected variables as simply Object
rather than as a specific type.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Dean" <de**@coveyacco unting.com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com... I wrote a simple App in Access 2003 but used the 2000 file format. The one module Requires reference to Microsoft Office 11.0 Object Library. However, the person I have the code to has Office 2003 but only Microsoft Office 9.0 Object Library.
Are they not backward compatible? Is there something the user can do to update this to Office 11?
Dean wrote: However, the person I have the code to has Office 2003 but only Microsoft Office 9.0 Object Library.
Could this be?
If the person has Office 2003 installed but no Office 11 Reference
available, then I would suspect a problem with the install. Since the Office
9 library is available, do they have both versions of Office installed? This
is possible to do, if done correctly.
--
Wayne Morgan
MS Access MVP
"Dean" <de**@coveyacco unting.com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com... I wrote a simple App in Access 2003 but used the 2000 file format. The one module Requires reference to Microsoft Office 11.0 Object Library. However, the person I have the code to has Office 2003 but only Microsoft Office 9.0 Object Library.
Are they not backward compatible? Is there something the user can do to update this to Office 11?
PS.
You say that they have the Office 9 library, the checked items at the top a
listed in preference order. In other words, Access will use these in the
order they're listed, hence the up and down buttons to the right of the
dialog. The unchecked references are listed in alphabetical order. Scroll
down the list to verify that the new library isn't there. If it is there,
you may have to uncheck the older one before it'll let you check the newer
one.
--
Wayne Morgan
MS Access MVP
"Dean" <de**@coveyacco unting.com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com... I wrote a simple App in Access 2003 but used the 2000 file format. The one module Requires reference to Microsoft Office 11.0 Object Library. However, the person I have the code to has Office 2003 but only Microsoft Office 9.0 Object Library.
Are they not backward compatible? Is there something the user can do to update this to Office 11?
"Dean" <de**@coveyacco unting.com> wrote in
news:11******** *************@o 13g2000cwo.goog legroups.com: I wrote a simple App in Access 2003 but used the 2000 file format. The one module Requires reference to Microsoft Office 11.0 Object Library. However, the person I have the code to has Office 2003 but only Microsoft Office 9.0 Object Library.
Are they not backward compatible? Is there something the user can do to update this to Office 11?
It may not matter. So far as I know, the Office object library is
unnecessary unless you use something in your code that is provided
by it (I've never found any need to do so), so you could try
removing the reference entirely and seeing if your code compiles.
I've seen the Office reference added in many times in my projects
and since I know for a fact that I never use anything from it, I
always simply remove the reference entirely.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"Dean" <de**@coveyacco unting.com> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. . The object does matter as I am using a file dialog and a folder dialog code.
I may follow Allen's advice on this. Something like http://www.mvps.org/access/api/api0001.htm may work nicely.
IMO - this is definitely the way to go if the application might be used by
multiple users. I had nightmares trying to keep track of which users had
which version of Office installed. There was no end to compatibility errors.
Code like that put an end to all of it. Permanently.
The code was written by Ken Getz, one of the authors of the Access
Developers Handbook (all versions). If you happen to have one of those, it
is on the included CD. The book has examples for using it.
Randy Harris
"Dean" <de**@coveyacco unting.com> wrote in
news:11******** **************@ g44g2000cwa.goo glegroups.com: The object does matter as I am using a file dialog and a folder dialog code.
Well, I would never do that. I always use the ADH code that directly
invokes the relevant APIs. From what I can tell, the code is not a
whole lot simpler, so I don't quite see why anyone would introduce
an outside dependency for something that can be done easily with
APIs.
I may follow Allen's advice on this. Something like http://www.mvps.org/access/api/api0001.htm may work nicely.
That's basically the code that I've used, though from a later
edition of the ADH.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Chuck Farah |
last post by:
I keep getting this error running a VB .NET web forms
application. I exit visual studio kill the aspnet_wp.exe
process and restart vs and works again. Any help would be
appreciated. Just to re-iterate not a consitent error.
Configuration Error
Description: An error occurred during the processing of a
configuration file required to service this request.
Please review the specific error details below and modify
|
by: Steve |
last post by:
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
|
by: ammd |
last post by:
Hi, I installed Microsoft DirectX 9.0 SDK (Summer 2004) but when I create a project and try to add the necessary references I can't find them. Does anybody know where to look for them? BTW, I have VS 2002. Don't know if there's an incompatibility issue. Thanks.
|
by: ShadowOfTheBeast |
last post by:
Hi all, is there any one who have developed an application in c# using a
text-speech engine using the Microsoft Speech SDK 5.1 especially using visual
studio.net IDE 2003 (v7.1) I seem to get an inter-op compiling error and cant
seem to resolve it! help!
--
The Matrix Insurrection
|
by: Oney |
last post by:
I use Microsoft Exception management block to publish exception to
event log. but some error occured. Error is blow, how can I solve this
problem ???
Configuration Error
Description: An error occurred during the processing of a
configuration file required to service this request. Please review the
specific error details below and modify your configuration file
appropriately.
| |
by: KMart |
last post by:
Hello,
I have a ASP.NET/C# application that uses the IE Web Controls. Everything
was working fine. Then, for some unknown reason, everything stopped working.
Here's the error information:
Server Error in '/application' Application.
----------------------------------------------------------------------------
----
|
by: bbdobuddy |
last post by:
Hi,
How do I open a Microsoft Access 2003 form from Visual Basic.net
Thanks in advance
bbdobuddy
|
by: Michael Russell |
last post by:
Hi all,
Using C#, I've created a simple wrapper class for using Excel. I have
Office Pro 2003 installed on my devel machine. The wrapper class works
great, reading and writing to/from Excel. To do this, I created a
reference to "Microsoft Excel 11.0 Object Library", and have a "using
Excel;" directive.
I decided to add a method for creating a TextBox using the
Shapes.AddTextBox method, which requires a
|
by: =?Utf-8?B?TWljaGFlbFF1aW5sYW4=?= |
last post by:
In my development environment I can add references to the Microsoft Practices
libraries and everything works ok. But when I copy the application to the
test server I get the message "CS0234: The type or namespace name 'Practices'
does not exist in the namespace 'Microsoft' (are you missing an assembly
reference?)".
A search of the web suggests that I am missing an assembly reference
(exactly as the message says). I cannot find any place...
|
by: VictorG |
last post by:
Hello,
I am trying to secure a webservice using WSE 3.0 and the turnkey
usernameForCertificateSecurity profile. I am passing a valid username
token, and on the server I have overridden the Authenticate token
call
and it is being called. My ASP.NET service has a Login() method and
it is being called during client application startup. Both the client
and service have matching policy config files. Once authentication
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |