We help IT Professionals succeed at work.
Get Started

Problem MDB not Functioning the same on different machines

mlcktmguy
mlcktmguy asked
on
227 Views
Last Modified: 2012-05-12
I work with a business partner in developing Access application.  We have worked together for over 15 years and always operated in the same manner, which is exchanging MDB's back and forth between machines to make enhancements or changes.
Usual workflow:  I work on the MDB, complete my changes send it to him.  He makes his changes and sends it back to me.  This has worked seamlessly, without issue, for a very long time thru several different versions of Access.

Recently I purchased a new Win 7 Ultimate system.  Now there are issues every time I send him an MDB.  I don't have issues with the revised MDB's that he sends to me.

If I revert back to developing on my old WIn XP machine there is no issue.  However on the new machine iIt happens every time and we have seen a pattern with the error and solution but have no idea how to resolve the problem permanently.

I have also had the same issue sending MDB's to client running Win XP/Access 2003.  I serviced these clients on my old XP machine for years without issue.

The error always occurs on a  "Set rs = New ADODB.Recordset" statement.  The message is something along the lines of "does not support automation".  

The foolproof way (so far)  of resolving the issue is for him to go into the "Tools","References" option.  He then clicks/checks on the first non clicked reference and then clicks/unchecks the reference.  The end result is no change to the reference list.  However, for some reason the problem goes away  .

The reference list:
Visual Basic For Applications
Microsoft Access 11.0 Object LIbrary
Ole Automation
Microsoft Active X Data Objects 2.5 Library
Microsoft DAO 3.6 Object LIbrary


My machine: Win 7 Ultimate, Access 2003 SP3

His machine XP Professional, Access 2003 SP3

Any ideas on what the issue is or how to resolve this ongoing problem?
Comment
Watch Question
President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE