Q. about App.Path

[chrisjk]

Originally posted by filburt1

DataSource = App.Path & "\file.mdb"

There was no backslash, and the + might have done something weird. Does the code help at all?

Not very likely but app.path could return "C:\", in which case that would blow up

Dim strAppPath as string
 
If right$(app.path,1) <> "\" Then
    strapppath=app.path & "\"
else
    strapppath=app.path
end if

That way, it will always have a backslash at the end