Data Base Paths.

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?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

uilleannConnect With a Mentor Commented:
Set Db = OpenDatabase(App.Path & "\Test.mdb", dbOpenTable)
BigwayAuthor Commented:
Thanks, thats perfect : )
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.