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
Joined
Jul 17, 2007
Messages
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

Moss100
  • Locked
  • Question Question
Remove everything including the comma from the last comma of a string.
Replies
10
Views
1K
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
619
Moss100
Moss100
M
  • Locked
  • Question Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
4K
SoftwareRT
SoftwareRT
Drago1920
  • Locked
  • Question Question
Finding the lowest date
Replies
2
Views
621
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top