Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Object Library name conflict

Posted on 2007-11-23
9
Medium Priority
?
452 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
9 Comments
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 20338537
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
ID: 20338572
Yes - that's what I've done.  So I don't understand why I'm getting the error
0
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 20338612
markremms,

Did you remove the Word reference?

Regards,

Patrick
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:markremms
ID: 20338615
Have written a batch file for the client to decompile the application in their environment.  Waiting to hear if that works....
0
 

Accepted Solution

by:
markremms earned 0 total points
ID: 20338878
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
ID: 20338891
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 93

Expert Comment

by:Patrick Matthews
ID: 20345601
Vee_Mod,

No objection here :)

Regards,

Patrick
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20362879
Closed, 500 points refunded.
Computer101
EE Admin
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

730 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