References : Latest headache part I

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

hello,

I have an application - water.mde - which run together with a library -
dbtools.mda -. This two file are located in :

C:\application\environment\water.mda
C:\application\Environment\libs\dbtools.mda

As you notice water.mde is compiled. When you compile it, the path to the
library to dbtools.mda is fixed (I usually compiled the library from another
disk than C:)

A setup.exe allows the client to install the application whereever the
client wants it to be installed.Thus the files are
installed in

{PathChosenByClient}\water.mda
{PathChosenByClient}\Libs\dbtools.mda

My problem is that the path to the library is of course different from the
path which has been defined during the mde-compilation of the water.mdb
application.

To avoid this I loop through the reference and once I found the name of the
reference corresponding to dbtools.mda, I remove the reference and add it
again.

My PROBLEM : this works perfecty well in the mdb-state but doesn't work in
the mde-state.

I saw plenty of mails regarding references in the newsgroup archives but
this issue was never tackled.

My QUESTION : are the two methods reference.REMOVE and reference.ADDFROMFILE
usable in a mde file ?
Is there an alternative to this ?

I am aware that MSaccess is seraching the library in different files, one of
them being the path declare in the refPathLibs key of the library, but again
this doesnot work.

Any help would be appreciated.

Thanks in advance

Michel
 
You say you have tried refpathlibs - but the key is actually reflibpaths.

Do a google groups search on reflibpaths. That gives lots of information.
For example, one poster says:

"I have used RefLibPaths for installing a compiled library to the
application directory on MANY client machines, and it has worked for me
using both Access 97 and Access 2000 under Windows 98, NT, and 2000."

Maybe try that method again? If you do, post back the results, because I've
always meant to check this out myself, but never got around to it.

HTH,
TC
 
Back
Top