Current Path? 1

[danomaniac]

I'm having difficulty getting the actual path that my database resides in. I want to be able to get the current directory when the main form loads then use it as my starting reference to add sub folders to, ie. '\images' , etc.
I use the CurDir and I get the default directory, not the actual directory the database is residing in. I've done this before, but can't remember how.

Thanks for any help.

"It's more like it is now, than it ever has been."

 

[ploeryan]

Hello

I use the below function;

Function CurrentDBDir(strDBPath As String, strDBFile As String) As String

CurrentDBDir = Left(strDBPath, Len(strDBPath) - Len(strDBFile))

' WHERE
'strDBPath = CurrentDB.Name
'strDBFile = Dir (CurrentDB.Name)

End Function

Regards

 

[RoyVidar]

Hi!

ploeryan's version is the dao variant. Using access 2000+ and ado;

[tt]currentproject.path[/tt]

Roy-Vidar

 

[danomaniac]

Thanks - exactly what I needed.

"It's more like it is now, than it ever has been."