Setting References

[DALIEN51]

Is it possible to set which VBA reference boxes are ticked each time a database is loaded?

A problem is created when a person amending the database to the person using it has different setups and so some of the references show as "missing" and so compile errors show on loading.

We are using Microsoft Access 97.

Any help most appreciated.

Dalien51

 

[The_Doc_Man]

Unfortunately, the only way to do this requires you to write VBA code that uses ... you guessed it ... references. In other words, the perfect Catch-22 (apologies to Joseph Heller). If the references are wrong, you won't be able to run the code that would correct the references. Typical Microsoft problem.

Since the references are stored in each individual workstation's registry (in the HKEY_LOCAL_MACHINE/SOFTWARE hive), the only REAL solution is to visit the involved machines and update their registries once each. It does not really hurt your system to have several items in the registry that only Access uses.

I don't know of a non-visitation solution unless you happen to have an approved scripting tool to update registry entries outside of Access context. Such things exist but most domain administrators would rather shoot you and do jail time for it than let you run an automated registry editor. Heck, if you tried that on MY system, your account would cease to exist within 24 hours. You would only do that once.