Microsoft Object Library 12 vs 11

I have an Access database developed under Office 11. I accidentally opened the database on a PC that was under Windows XP  but had Office 12 on it. Now I have a missing reference to Microsoft Object Library 12 in the code somewhere and I get the error "Unable to load DLL"
Question,  is there any easy way that an amature can remove or replace the referece so my database is referencing Microsoft object Code 11?  Alternatively, Is it possible to add the missing object code to my system, without installing Office 2007 ? etc. ?
jwjjwjAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Back on your Office 11 system:

1) open the vba editor
2) Tools >> References
3) Uncheck the **Missing reference
close ... and save the project.

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I had the exact same issue on a downloaded EE file from a question.  All you have to do is uncheck that reference.

mx
0
jwjjwjAuthor Commented:
That was the first thing I tried. Unfortunately, I then receive a vb error "can't perform requested operation", and the reference is re-ticked as missing
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Can you:

1) Compact & Repair (*** to shrink the size),

2) Zip up the MDB (*** to further shrink the size)

3) Attach the file for upload here (using the 'Attach File function below) ... removing any sensitive data of course.

4**** And please give a clear explanation of exactly how to reproduce the problem or what you are trying to do.

mx
0
jwjjwjAuthor Commented:
Thanks MX, however i'd rather not do that, the DB is abou 80Mb and full of sensitive info. I have tested on a spare PC and can work round the problem by loading office 2007 on the same machine, then the DB works fine, but that is not what I want.
I suspect the reason I get the error 'Can't perform requested operation' on un-ticking the Missing Reference to Outlook Object Library 12" is because it replaced (somehow) the genuine reference to Microsoft Object Library 11" (I can see this on an older backup copy of the DB)
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Well, then try setting a reference to Microsoft Object Library 11 ... close and save ... and *then* try remove the 12 reference.

And/Or ... you can try to remove the 'stuck' reference with this code:

Public Function SSF_RemoveReference() As Boolean

    Dim ref As Reference
    Set ref = References!MSForms    'specify the reference to remove - you need to get correct name
    Dim x
    References.Remove ref                       ' this line removes the specified reference
 
    'option code to list references to help get the name
     For x = 1 To References.Count
        Debug.Print References(x).Name
    Next x
       
End Function
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Build a new, blank database on the Office 11 machine, then import everything to that new database (click File - External Data - Import).
0
jwjjwjAuthor Commented:
Thank you MX and LSM,  
LSM, I did try that however as soon as Imported any Forms (not sure how many as I have quite a few), and went to actually use the forms, I received the same error.

However, I think I have corrected the problem by paritially following the lines from MX.
On a 2007 machine, I installed Office 2003 and then was able to open the original database, albeit with a couple of coding errors, I ignored the coding erros and once able to successfully open the VBA Editor, I was able to successfully remove the 'missing Microsoft Object Library 12' reference. Then with this gone, I returned the DB to the Office 2003 PC's and the DB appears to be working ok.

Again thanks for your prompt assistance.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.