I'm using vb.net. How do i go about changing the location of where my access database is stored? For example, i have my database listed in c:/database.mdb. One group of users may be able to change the location to c:/newlocation/database.mdb. How can i alter my code so that it points to the new location without having to re-edit my code everytime i log in?
Not sure how you would do it in VB.net but in VB 6 i store the location of the database in a string variable, (this can be picked up from an ini file) and then use this string variable as part of the connection string.