Application Path?

[Sean]

Is there code to determine the path of the database?

I compile to MDE which calls for ODBC connections, but I want to switch this
to a 'file dsn' so that each instance of the MDE can have it's own
conenctions to databases.

Sean

 

[Brendan Reynolds]

CurrentProject.Path

Returns the path without the trailing "\" character, so remember to append
that, e.g. ...

strMyDsn = CurrentProject.Path & "\MyDsn.dsn"

 

[Sean]

Many thanks.

CurrentProject.Path

Returns the path without the trailing "\" character, so remember to append
that, e.g. ...

strMyDsn = CurrentProject.Path & "\MyDsn.dsn"