Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 2nd, 2006, 11:49 AM
Authorized User
 
Join Date: Jun 2006
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default ADO Ext library

Hello everyone,

I am working on many Access applications where I make use of the ADO Ext library in my VBA code. After sending it out an application for testing, some of the end users get a reference error for this library (even if they are running the same version of Access). The quick fix is simple, they just go into references and find the ADO Ext version that they have. It is a little irksome for end users to have to do this every time they get a new version of the application.

Does anyone know if there is a way I could distribute this library to the end users so that they will not have to make the reference change every time? I am still relatively new to Office development, and I am not really familiar with installing and importing new libraries (and have absolutely no idea how to make user created libraries). Anyways, thanks for any help.

  #2 (permalink)  
Old November 3rd, 2006, 08:38 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Sounds like you need an installer app.

Also, you should have better configuration control when developing apps. If you, as the developer, have lots of cool stuff running in your app, you need to test the app on a standard desktop machine for your working environment.

I have a second workstation at my desk with a plain vanilla install for my agency, and I test all my development on it if it is going to more than a few clients. Otherwise you have to get an installer to make sure the references are there.

I looked around to try to find the registry settings for references, but didn't have much luck. Perhaps you can get a registry watcher, and then remove and replace your references and see if anything is happening in there. The references refer to .DLL files, as I understand it. But that may be wrong. Anyway, dll references are in the registry in various places.

HTH

mmcdonal
  #3 (permalink)  
Old November 3rd, 2006, 08:39 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I forgot to mention, if it is a registry setting, I can give you code to make sure the settings are correct when the app launches.

mmcdonal
  #4 (permalink)  
Old November 3rd, 2006, 10:46 AM
Authorized User
 
Join Date: Jun 2006
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you for the feedback. Are there any installer apps that you would recommend?



Similar Threads
Thread Thread Starter Forum Replies Last Post
Ch 8: <asp:image> inside <a> & ext.CSS (pg. 274) epc BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 1 July 12th, 2008 04:37 AM
DTS ignores a 2nd ext when loading a txt file mmusleh SQL Server 2000 5 July 24th, 2007 01:53 PM
ado type library in global.asa -Dman100- Classic ASP Professional 4 August 6th, 2004 09:45 PM
FPSpread ADO type library rajupusapati ADO.NET 0 January 22nd, 2004 12:44 PM
ADO could ADO counot find the specified provider. Rob Collie Classic ASP Databases 2 June 9th, 2003 04:12 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.