Application Path?

  • Thread starter Thread starter Sean
  • Start date Start date
S

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
 
CurrentProject.Path

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

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

Brendan Reynolds said:
CurrentProject.Path

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

strMyDsn = CurrentProject.Path & "\MyDsn.dsn"
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Create MDE 1
Create datasheet in MDE 6
MDE problem 6
error message 1
MS Access with Linked tables Security Issue 5
Restart Exclusive and then Backup Database? 2
Problems with different versions of Access 6
Change Start Up options at Start Up 6

Back
Top