Checking the pathname

[Guest]

Can someone please supply me with a boolean function for Access 2003 to
return true or false depending on whether the pathname for the database
starts with C: (i.e. it's running on my local hard drive)?

 

[Stefan Hoffmann]

hi EPA,

EPA in Germany is the food package you'll get in the army, which can be
stored and used for over 15 years. Yummy!

Can someone please supply me with a boolean function for Access 2003 to
return true or false depending on whether the pathname for the database
starts with C: (i.e. it's running on my local hard drive)?

(Left(CurrentDb.Name, 2) = "C:")

of it it is an .adp

(Left(CurrentProject.Name, 2) = "C:")


mfG
--> stefan <--

 

[Guest]

IsLocal = Left(CurrentDb.Name,2) = "C:"