[AccessD] Removing a missing reference

Rocky,

I still think the easiest and the most reliable solution for your case is to
use late binding. Did I miss something in this thread - why it didn't work
for you?

If you decide to not use late binding and if remove reference doesn't work
for you - then you can use Add Reference (anyway your intention to use
Remove Reference forces your FE to loose its compiled state as well as Add
Reference does).

I mean the following:
 
- put all your bar code printing code into a separate library/utility
database, set reference to bar code printing library in this database;

- in your FE keep the code to check is it possible to create bar code
printing object or not;

- if it's possible to create bar code printing object then add reference to
its library (code to add reference MUST BE kept in another library database
- if executed in FE such will force FEs global vars to loose their values);

Etc.

This above is a flexible solution but its above description isn't a full
story - in this case if your FE uses global variables then you have to
create another "proxy" FE to keep start-up code, (dynamic) references,
commandbars... and use your current FE as a library database - then
CurrentDb if you use it becomes a problem etc.

This above technique works very well - it was used in real life apps here
and there back to the years 1998-2000 but program databases and their code
should be refactored to be used within this technique....

It's very shortly described here - "A method to modularize MS Access
applications" - http://smsconsulting.spb.ru/shamil_s/downloads.htm

But applying it for your case looks like using "cannons to shoot at
nightingales" - why not use simple and effective late binding?

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Tuesday, August 08, 2006 11:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Removing a missing reference

Marty:

Access.References.Remove refCurr still generates error: -2147319779 - Object
library not registered.  

Rocky