Q. about App.Path

[FNC]

I am trying to use app.path to denote the location of a database.

I am writing DataSource = App.Path + "file.mdb"

but it instead of adding c:\folder\file.mdb

it gives c:\folder\app.path\file.mdb

What gives?

Why is app.path added to the path??

Thanks.

[filburt1]

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

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

[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

[filburt1]

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

Just to clarify, it doesn't have to be the C: drive; it could return "D:\", "X:\", etc.

BTW, does App.Path work with UNC paths?

[chrisjk]

Originally posted by filburt1
Just to clarify, it doesn't have to be the C: drive; it could return "D:\", "X:\", etc.

I think you know what I meant!

BTW, does App.Path work with UNC paths?

Not on a network at the moment so can't find out. I should think so though

[filburt1]

Originally posted by chrisjk
I think you know what I meant!

I know , I was just making sure everybody else did.

[honeybee]

Originally posted by FNC
I am trying to use app.path to denote the location of a database.

I am writing DataSource = App.Path + "file.mdb"

but it instead of adding c:\folder\file.mdb

it gives c:\folder\app.path\file.mdb

What gives?

Why is app.path added to the path??

Thanks.

The only way you could have got that result is if you enclosed App.Path in double quotation marks, i.e. instead of writing App.Path if you wrote "App.Path".

.

[filburt1]

Originally posted by honeybee
The only way you could have got that result is if you enclosed App.Path in double quotation marks, i.e. instead of writing App.Path if you wrote "App.Path".

For example, you might have typed "App.Path file.mdb", where App.Path would not have been parsed.