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 Mike Lewis 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
0
0
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
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
302
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
212
Moss100
Moss100
M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
0
Views
35
MikkiJ
M
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
179
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Make database appear as just a form
Replies
1
Views
96
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top