Access Reference Problem

[amazo]

Hi everydody,

I have a problem with a local library reference and I can't find out
the solution. I explain:

.. I develop in Access 97 on a computer with a only drive C:
.. I have created a local mde database with my common functions,
procedures, etc. (let's call it "B")
.. I have attached this mde database to my current database (let's call
it "A") thru references.
.. ... and everything is fine.

.. Now, I have a new computer with 2 drives, C: and D:
.. I have copied my previous 2 databases to drive D: and things go
wrong due "B" database because it is located in a different drive.
.. If I open the "A" database I can see that "B" reference path is
pointing to current drive D: but the only way things go properly is
deselect "B" reference and select it again.

This is my question: How can I move my app ("A" plus "B") to a
diferent drive/folder without having to deselect/select again "B"
reference?

Thanks in advance.

Angel.

 

[punjab_tom]

Dont use JET
Dont use Access 97

stick a fucking cork in it and outsource it to someone that uses
current version

 

[Jerry Whittle]

Link your master MDB file to the D drive database. Then create an MDE.

 

[Tony Toews [MVP]]

This is my question: How can I move my app ("A" plus "B") to a
diferent drive/folder without having to deselect/select again "B"
reference?

If the main app is an MDB Access will attempt to resolve the
reference by looking in some directories. Whereas it will do next to
nothing to resolve references for MDEs.

You need to set the RefLibPaths registry key so Access knows where to
go looking for it. See my Add-in Tips, Hints and Gotchas page at
http://www.granite.ab.ca/access/addins.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[amazo]

Hi Tony,

Thanks for your info about.

Do you know where can I find some *.REG example to modify accordingly
and to execute on my customer sites to:

.. to create the "RefLibPaths" info for my mde library (the first time)
.. to modify that registry info in case I desire to move app + library
to another drive/folder

Thanks so much.

Angel.

 

[Tony Toews [MVP]]

Do you know where can I find some *.REG example to modify accordingly
and to execute on my customer sites to:

From within regedit create the registry keys yourself and then export
the key and such.

. to create the "RefLibPaths" info for my mde library (the first time)
. to modify that registry info in case I desire to move app + library
to another drive/folder

I would suggest using API calls from your app to update the registry.

However you may want to follow the suggestions as at
http://www.trigeminal.com/usenet/usenet026.asp?1033 . Although those
might not be enough to solve your problems.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm