Ken, A bit late in the day perhaps, but here's my ha'penny worth. I've been working with Access for about 10 years. >when you are writing code, what reference do you need to perform which >functions and operations. You only need to add references to 3rd party libraries or objects, when you want to use them in your code. For example, if you want to play with Outlook (send a mail, read an address book, etc) from code in Access, then you add a reference to the Outlook type library. Lots of vendors of software expose their objects through automation in this way, and allow you to drive their programs through VBA code in Access, as you've probably noticed when you scroll through the list of available references. I don't use ADO at all if I can avoid it... >And, more importantly, when you are trying to do something which needs one >of these, how do you find out which reference to make? Um, honestly?! Mostly (blush) by guesswork and trying it out!! Also, searching on google for sample code usually does the trick. HTH. David David Landy, IT Consultant Business Intelligence Somerfield/KwikSave +44 (0) 117-301-8977 david.landy at somerfield.co.uk <mailto:david.landy at somerfield.co.uk> Don't be afraid to try something new. An amateur built the Ark. Professionals built the Titanic. Author unknown. -----Original Message----- From: Ken Moore [mailto:psm2713 at hotmail.com] Sent: Tuesday, 24 February 2004 15:04 To: thelist at lists.evolt.org Subject: [thelist] MS Access References Hi all, I have used Access for several years. Although I have looked mightily, I have never been abel to find a complete list of module references. That is, when you are writing code, what reference do you need to perform which functions and operations. For example, when would you need to add the MS ActiveX Data Objects 2.0 Library? And, more importantly, when you are trying to do something which needs one of these, how do you find out which reference to make? TIA, Ken _________________________________________________________________ Store more e-mails with MSN Hotmail Extra Storage - 4 plans to choose from! http://click.atdmt.com/AVE/go/onm00200362ave/direct/01/ -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! If you are not the intended recipient of this e-mail, please preserve the confidentiality of it and advise the sender immediately of any error in transmission. Any disclosure, copying, distribution or action taken, or omitted to be taken, by an unauthorised recipient in reliance upon the contents of this e-mail is prohibited. Somerfield cannot accept liability for any damage which you may sustain as a result of software viruses so please carry out your own virus checks before opening an attachment. In replying to this e-mail you are granting the right for that reply to be forwarded to any other individual within the business and also to be read by others. Any views expressed by an individual within this message do not necessarily reflect the views of Somerfield. Somerfield reserves the right to intercept, monitor and record communications for lawful business purposes.