>Example: User A wants files on drive R:
>User B wants same files but computer points to Drive M:
>How do I get the program to figure out the drive letter?

At the user recognition level, when doing the startup, you can assign the necessary drive letter to the global variable handling the path directory of your tables and then use that whenever you open a table.

>Please e-mail me at SCHNEIS1@Nationwide.com

Everyone can benefit of the received answers to your question, so please don't redirect a reply by email.