Hi,

I have designed a multiuser access 2000 database with a FE
and BE and .mdw file.  The BE and .mdw are on a shared
network folder and the FE resides on each users machine.  
I (with great help from this newsgroup!) then designed a
link to tie all three together.  The problem I am
encountering is that different users have Access 2000
installed in different directories (ie. office v. office1
v. office2000), and most also have access 97 (hence the
multiple access locations).  The link keeps getting
confused from machine to machine and if the link target is
changed to 97 by accident the link completely stops
working.  Unfortunately it is not feasible for me to
standardize the location of 2k on every users machine.  
Does anyone know how I can make a "smart" link that will
always find and open the proper version of access no
matter where it resides?

Secondly, I'm having the same issue on the code side.  I
have created an auto-update client (also thanks to this
newsgroup) that uses an 'update' db to copy down the
newest version of the FE to the clients desktop.  The
update db then reopens the FE after the new file has been
copied.  I got some great code from an mvp that calls the
aforementioned link to open the FE db securely.  It
follows:

Dim strOpenClient As String
Dim RetVal As Long
Const Dq As String = """"

strOpenClient = Dq & "C:\Program Files\Microsoft Office1
\Office\MSACCESS.EXE" & Dq & " "

strOpenClient = strOpenClient & Dq
& "c:\AnalyticalDatabase\PDAnalyticalDatabase.mdb" & Dq

strOpenClient = strOpenClient & " /wrkgrp:" & Dq & "S:\ARI
PD\PD Analytical Database\Database File\MDW
File\ANALYTICAL.MDW" & Dq

RetVal = Shell(strOpenClient, vbMaximizedFocus)

If RetVal Then AppActivate RetVal

As you can see I hardcoded the location of access 2k to
the 'Office1' folder as this is most commonly where it is
located.  Does anyone know how I can make code to find
where access 2k is on the current machine and then store
that location in the string variable rather that
hardcoding a location?

I know this is a long post and I really appreciate any
help!  Thanks in advance,

Eric