Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine the default folder of database

Status
Not open for further replies.
marle35

marle35

Programmer
Jul 17, 2007
36
Is there a way to programmatically determine either the "default folder" or the folder path that the database file resides in?
 
Sort by date Sort by votes
What about CurrentProject.Path ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
strDBPath = CurrentDb.Name
DataBaseName = Dir(strDBPath)
CurrentFolder = Left(strDBPath, InStr(strDBPath, DataBaseName) - 1)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Knicks
  • Question Question
Nested Column (Excel, CSV) : How to extract just the metadata or column names within a column of data
Replies
2
Views
170
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question Question
Remove everything including the comma from the last comma of a string.
Replies
10
Views
2K
Andrzejek
Andrzejek
breezett93
  • Locked
  • Question Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open
Replies
14
Views
3K
dhookom
dhookom
Moss100
  • Locked
  • Question Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
632
Moss100
Moss100
Drago1920
  • Locked
  • Question Question
Finding the lowest date
Replies
2
Views
634
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top