Solved: reference necessary?

[eed]

Hi, all,

My question is about references. I don't necessarily know a lot about these, so please bear with me.

I am using a modified version of some code, originally provided by an Access book that I purchased, which formats a recordset as a Word table in a Word document. The original module included a reference to "Microsoft ADO Ext. 2.5 for DDL and Security," so I also included this reference in my tool.

However, between making changes in a file copy on my desktop and transferring those changes to a file copy on my company's network, this reference keeps going a bit screwy. Sometimes, all of a sudden, with no apparent cause and occuring in no apparent pattern, the file copy on the network will have a MISSING reference to "...ADO Ext. 2.8..." It then has to be changed back to the 2.5 reference for the file to operate correctly.

To begin with, I have no idea what is causing the correct 2.5 reference to suddenly morph into a MISSING 2.8 reference. But my real question is this: is there a good reason why my database should include this reference at all? My procedures seem to run just fine if I exclude it from my reference list. But the Microsoft article at this address - http://support.microsoft.com/kb/825796/ - seems to suggest that I ought to be using it, though I'm not sure I understand why.

I'd appreciate any insight on whether I could just exclude this reference, or on why the erroneous reference to 2.8 keeps appearing...
By the way, I'm working with Access 2003 SP1 in Windows 2000 Pro SP4.
Thanks!!!

~ eed

[OBP]

It sounds as if the book was writen for an older version of Access than you are curretly using. Hence the "morphing" of the reference from 2.5 to 2.8 which is probably the normal reference to ADO in your version of Access. Usualy later versions include most of the requirements of earlier versions and more.

[geekgirlau]

This may also explain why the code works without the reference - if the sample came from an older version, you may find that the functionality is built-in to your current version without the external reference.

IMHO if the code works without the reference, you don't need it.

[eed]

Thanks for the replies, OBP and geekgirlau.

The 2.5 version is the only option Access gives me on my computer; it doesn't list 2.8. The only time 2.8 appears is after the database has been edited on the network server, and the 2.8 always appears marked as "MISSING," it never appears in a functional way.

I am inclined to agree with geekgirlau's assessment that I probably don't need the reference if the procedure works without it... I just wanted confirmation from someone more knowledgeable on the subject than myself. :blush

Thanks for the input!

eed