I have a vb6 application that uses a file .dsn to locate the database on the server:
DRIVER=Driver do Microsoft Access (*.mdb)
It has been requested of me to change this or use a different method for locating the database. The reason for the request is because the user wants to be able to avoid errors being thrown if the server changes, etc. The person requesting the change wants to eliminate the "hard coding" so the application won't be dependant upon this directory path. Is it possible to create something in an install package to where it points to the location of the database? Is this possible?