Determine if file is on local PC

[robert d via AccessMonster.com]

I need to determine for sure if a particular fie is on the user's local PC or
on the server. I have the complete path of the file, let's call it

FullFilePath

How can I unequivocally determine if this is on the local PC or on a server
or other machine. The local computer may have more than one hard drive but if
the file is on any of these local hard drives I would want the code to
produce a result that the file is on the local PC. I guess we'll assume that
if the file is on a jump drive or CD that that is not the local PC.

I guess I'm wary of looking for typical hard drive letters in the file path
to make my determination. Is there another way?

Thank you.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200602/1

[salad]

robert d via AccessMonster.com wrote:

I need to determine for sure if a particular fie is on the user's local PC or
on the server. I have the complete path of the file, let's call it

FullFilePath

How can I unequivocally determine if this is on the local PC or on a server
or other machine. The local computer may have more than one hard drive but if
the file is on any of these local hard drives I would want the code to
produce a result that the file is on the local PC. I guess we'll assume that
if the file is on a jump drive or CD that that is not the local PC.

I guess I'm wary of looking for typical hard drive letters in the file path
to make my determination. Is there another way?

Thank you.

This may or may not assist.
http://www.mvps.org/access/api/api0003.htm

[Ted]

When you check out the code at the link salad provided
(http://www.mvps.org/access/api/api0003.htm
), do what I did and modify the code to store that data in a table so
you can refer to it later. It is great code and I have integrated it
with several applications I have created where I need to be able to
determine what type of a drive a particular drive is.
Note in the code that it determines if the drive in question is a
network drive as well.
In one case I adapted that code into an application I created that
searched drives and catalogs the files so that I can search for the
files later. I use it to catalog files I have stored on CD, DVDs,
External HDD, etc. Very useful code!