Solved

Object Library name conflict

Posted on 2007-11-23
9
444 Views
Last Modified: 2008-02-01
I have developed an Access database using Access 2003 for a client.

The client is running the database on Access 2002.

I have built some custom code for emailing from the database and creating Word docs.  All works fine on my machine.
In the past I have had to talk the client through unticking references in the Tools menu of VB so that the software would work properly.  And up to now that has been fine.  Today this is not possible error message:
"Name conflicts with existing.... etc"

is produced when trying to untick the references.
The client's machines have Microsoft Word/Outlook 10.0 Object Library and mine has version 11.0

What to do?
0
Comment
Question by:markremms
  • 4
  • 3
9 Comments
 
LVL 92

Expert Comment

by:Patrick Matthews
Comment Utility
Hello markremms,

> What to do?

I try to go with late binding whenever I have to do OLE automation of one Office app from another.
This mitigates the problems you may run into when your users are on a different version of
Office than the developer.

A quickie summary on the pros and cons:
http://word.mvps.org/FAQs/InterDev/EarlyvsLateBinding.htm

If you need some hints on how to convert your current code, please post what you have.

Regards,

Patrick
0
 

Author Comment

by:markremms
Comment Utility
Yes - that's what I've done.  So I don't understand why I'm getting the error
0
 
LVL 92

Expert Comment

by:Patrick Matthews
Comment Utility
markremms,

Did you remove the Word reference?

Regards,

Patrick
0
 

Author Comment

by:markremms
Comment Utility
Have written a batch file for the client to decompile the application in their environment.  Waiting to hear if that works....
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Accepted Solution

by:
markremms earned 0 total points
Comment Utility
Turned out not to be the object library that was the problem but oddly the use of the date function.  By using the Now() function instead the problem is solved.  An earlier version of the same dataabse works fine with the Date function,  I don't think I've made any changes that would cause this....but I must have done something..
0
 

Author Comment

by:markremms
Comment Utility
Note to self:

Just because you think your client on the other end of the phone says a problem is a certain way doesn't mean it really is.
0
 
LVL 92

Expert Comment

by:Patrick Matthews
Comment Utility
Vee_Mod,

No objection here :)

Regards,

Patrick
0
 
LVL 1

Expert Comment

by:Computer101
Comment Utility
Closed, 500 points refunded.
Computer101
EE Admin
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now