Oct 2, 2007 #1 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?
Is there a way to programmatically determine either the "default folder" or the folder path that the database file resides in?
Oct 2, 2007 #2 PHV MIS Nov 8, 2002 53,708 FR What about CurrentProject.Path ? Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
Oct 3, 2007 #3 TimTDP Technical User Feb 15, 2004 373 ZA strDBPath = CurrentDb.Name DataBaseName = Dir(strDBPath) CurrentFolder = Left(strDBPath, InStr(strDBPath, DataBaseName) - 1) Upvote 0 Downvote
strDBPath = CurrentDb.Name DataBaseName = Dir(strDBPath) CurrentFolder = Left(strDBPath, InStr(strDBPath, DataBaseName) - 1)