I am looking for a way to provide a generic path to a database in a VB.NET application. This would be for an application and database that would be copied and installed on multiple PCs. The database is not necessarily shared. One answer I know of is to assume and demand that the application be installed with the same path to the database. For example, if the path on my "developers" PC was to a database on X:Path, then all installations would have to have a X: drive and a folder Path.
Thus, one question is, can this be automated with some installation software or controlled by some other means?
Secondly, if the database was just kept on the same drive and same folder as the exe, how can the exe be coded to find this database without an explicit drive and folder?