Hi
I have a access database which has been working for a number of years on a
single computer.
I have just put it on a network - 1 machine has fe/be and 2 have fe

Some word documents can be opened from the home form by code from command
buttons with this example


Private Sub Command59_Click()
Dim Word As Object
Set Word = CreateObject("Word.Application")
Word.Visible = True
On Error Resume Next
Word.Documents.Open FileName:="C:\data\Dairy
Stuff\custletters\pricelist0608.doc"
If Err.Number = 5174 Then
MsgBox "YourFileField" & " not found"
Exit Sub
End If


End Sub


However the path on the main machine is now different to the other 2.

to avoid having to go into the code

My thought was to have a table in the be holding the paths with the main
machine 1 and the other two 2
The registation table on the front ends would carry 1 or2
then modify the code above to
If =DLookUp("[wordpath]","[REGISTRATIONtbl]")= 1 Then

At this point I`ve got stuck -
So is this the best approach and if so what do I need to follow with to get
the grab the path ?

TIA
David