Make Distributed DB use References

[Dave Elliott]

How can I or can I make a db that is copied from one machine to another
correctly use the original references via the modules?
It seems that access loses the references that were originally used!

 

['69 Camaro]

Hi, Dave.

How can I or can I make a db that is copied from one machine to another
correctly use the original references via the modules?

The referenced libraries are not located in the same path on the second
computer as they are on the first computer. There are three ways to solve
this problem:

1.) Configure both computers with identical file paths for the library
files referenced by the database application; or

2.) When the database application is migrated to the second computer, open
any module in the VB Editor, compile all of the modules, and add any missing
references if necessary; or

3.) Use VBA to programmatically drop, then add, the necessary references
(using the second computer's file paths) to the References Collection at
start up. This can only be done with the non-default references. The
default references aren't going to be dropped from the collection, no matter
how hard you try.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Dave Elliott]

Suggestion (3) is the way to go, however I dont enough vba experience to do
this.
Thanks,

 

['69 Camaro]

Hi, Dave.

Make sure that your code to fix any broken references runs before _any_
other code runs at startup. Here is a code sample to programmatically drop,
then add, non-default missing references at startup:

http://groups.google.com/groups?hl=en&lr=&c2coff=1&selm=uBLD22xo$GA.257@cppssbbsa05&rnum=4

This sample includes some explanations of some "bumps in the road" that one
might encounter when adding certain references:

http://groups.google.com/groups?hl=en&lr=&c2coff=1&th=7b2df2b58df741dd&rnum=2

And here is an article written by Michael Kaplan with lots of excellent
information about broken references, as well as a few links to other
information on the Web:

http://www.trigeminal.com/usenet/usenet026.asp?1033

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)