I have been told and seen references to not Hard Coding my paths. For example: Set dbsJumpLog = OpenDatabase("C:\JumpLog\JumpLog.mdb").
I can see the wisdom in not doing this however I do not know the alternate way. After looking through a few thousand questions in the archive I have decided it would be worth a few points to gain this knowledge. Can you help me?