Referencing Library

  • Thread starter Thread starter Patrick Graham
  • Start date Start date
P

Patrick Graham

Hello,


I had a report that used the Format function within its
heading. Everything worked fine for everyone.

Now only my comp (running 2002) will load the report.
Everyone else (2000) gives format as being unrecognized.
I think it has something to do with a library reference.
On someones 2000 computer I was looking at references and
noticed that MS Office 10.0 Library was MISSING. I think
I may have removed the reference on their computer.

But when I look at the file from my computer the
reference is still linked.

Are references not universally added and removed from the
file or are the comp specific?

Anyone know what the fix is?
 
References are essentially pointers stored in the database.

If you open the database from machine A, and a specific reference isn't
available on machine A, it'll show up as MISSING. However, anyone else
opening that same database who has that reference won't have a problem.

If you're using Access 2000, you must use MS Office 9.0 Library.
 
-----Original Message-----
References are essentially pointers stored in the database.

If you open the database from machine A, and a specific reference isn't
available on machine A, it'll show up as MISSING. However, anyone else
opening that same database who has that reference won't have a problem.

If you're using Access 2000, you must use MS Office 9.0 Library.
Click to expand...

Hi Patrick, something to consider is using late binding
instead of early binding. That is using...

Dim objWord as Object
set objWord =CreateObject(,"Word.Application")

rather than
Dim wdApp as Word.Application
set wdApp =CreateObject(,"Word.Application")

The same use for object. Just different declaration.

This will mean that you do not require the word (for
example) object library explicitly referenced in your
application. So that you will avoid office version issues
in your application reference library.

Luck
Jonathan
 
Back
Top