Check current drive and directory...

[Inquisitor99]

I need to check if a database is running from a specific drive and directory. I tried using the "CurDir" function, but that does not give me the path that the database is currently located in, it appears to give me the last path that it was located in or created in, but it does not change no matter what drive I open the database from.


Here is a sample of the code I'm using:

If CurDir="F:\DatabaseFiles" then
Msgbox "Please do not use the database from this location"
End If

Is there a different command available to check the drive and directory that the database is "currently" running under?

Thanks.

 

[Remou]

Have you looked at CurrentProject.Path?

 

[mp9]

Check what CurrentDb.Name starts with?

http://www22.brinkster.com/accessory/

 

[Inquisitor99]

Excellent!!! Thanks Remou - the CurrentProjectPath is exactly what I needed. I tried it and it works like a charm no matter what drive or directory the database file is located under.