CurDir() doesn't give current directory

[bdaniel]

DIM'ng variable spath as string, then assigning value spath=CurDir().

When I move the program to another user's computer, CurDir() equals the users directory path, not the location of the database. For example I can put the database anywhere on my computer and it references the correct directory, I put it on my wife's computer and CurDir returns c:\users\patrice\documents even though the database is located in c:\users\patrice\documents\production module test\production module test(2).

When I placed the program on my work server, CurDir() returns c:\.



Any ideas?

Was using this so the program would reference files located in the folder the database is located. Guess if doesn't work, will just have to hard code the location into the program by declaring a string value to the directory path.

[boblarson]

CurrDir is not what you want. You want

CurrentProject.Path

is what you want. But to return that you will need to create a function:

Function GetCurDir() As String
    GetCurDir = CurrentProject.Path
End Function

and then you can call it

=GetCurDir()

[June7]

Try:
CurrentProject.Path & "\"

Check out http://www.ammara.com/access_image_f...base_path.html

[boblarson]

I just tested and this works in 2010 (not sure about 2007):

=[Currentproject].[path]

So you may not need the wrapper function.

[bdaniel]

Thanks. That works.