Code to allow MS Access database to determine whether it's being run from a network
Posted on 2013-12-18
Is there a catch-all way for an Access database frontend to detect whether it's being opened from a network location (mapped to a drive or not) versus the user's hard drive?
I want to keep the frontends off the network so that multiple users don't use the same copy, and to reduce traffic.
I know about Currentdb.name, and I know what drive letters we use for network locations, but I want something that will work anywhere.