2002 & 2003

[ted medin]

Our office uses office xp (2002). I had been doing work @ home using xp but
finally got 2003 & now when I move vba programs between the two I get
'automation errors'. Anyone got a solution for this? TIA

 

[Guest]

Have you checked for missing references? Here are two excellent articles on
this topic:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[n6trf]

Yes I did have a missing/.../web components/10: 2002 had owc10.dll while
2003 wouldn't take that to solve the missing. However browsing to .../web
components/.../11 had a owc11.dll which did produce a new reference that
made things like 'trim' work but didn't get rid if the missing. Now with
that said I still got automation error when I tried to copy a vba program to
the 2002 db while in 2003 or was it visa versa :-(. Let me try to clear this
up a bit. running 2003 I opened the 2002 db & tried to copy a vba program to
the 2002 db. Anyone got any ideas? TIA

 

[Guest]

Okay, are you sure you even need the reference to the Office Web Components
library? Try unchecking it, and then clicking on OK to dismiss the
references dialog. Then try compiling your code (Debug > Compile
ProjectName). If your code compiles without an error, then you did not need
the reference at all.

I don't understand the last part of one of your statements:
"...but didn't get rid if the missing."

I'm also not understanding this statement:
"running 2003 I opened the 2002 db & tried to copy a vba program to the 2002
db."

Do you have any compile errors?
Do all PC's involved have the latest service packs for the operating system,
the version of Office, and the JET database engine? Use this Knowledge Base
article as a guide to help determine whether or not each PC is fully updated:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________