The website I'm developing has many Gridviews ,Detailviews and so many Access Data Sources. The path to all my access database files is :

~/DB/AccessDB.MDB

when I need to deploy my website , I need to change this path to point to the directory where I'm allowed to keep my access files , sometimes like :

D:/somewhere/DB/AccessDB.MDB


The question is , how can I specifiy a single path for all my gridviews , detailviews and access data sources ?

I thought of using a session to store the path and use it all over the website, so I would simply change the session to "~/DB/AccessDB.MDB" on my computer , and right before I deploy the site , I change the session to "D:/somewhere/DB/AccessDB.MDB"

Is it a good idea?