Solved: Database Drive

[gsdonald]

Hi all,
Does anyone know a simple code that would return the letter "C" or "D" or whatever, that the database was being running from?
Thanks ...
gsdonald

[Apps]

Sub xPath()
xDrive = Left(CurrentProject.Path, 1)
'Debug.Print xDrive
End Sub

That should sort you out ok.
Regards,
Apps

[gsdonald]

Thanks.
That works perfectly.

Ciao