I decided I needed to keep the database in only one location, since it was driving me nuts to have different copies of it around depending on whether I was in Debug mode or Design mode. But I wanted to take advantage of the |DataDirectory| macro so I run the code attached on start up and I copied the database to that location....
My question is, does it make sense to put it at that location or is there a better approach?
I am interested in hearing your responses.
Thanks for your help.
Public Function SetDataString(ByRef lex As LastException) As Boolean
ConnString = Application.CommonAppDataPath