[2005] Server Path of the database

[bomayed]

The web hosting company asked me to save my database in this folder:

/USER/DB


How do I change this line :

<asp:AccessDataSource ID="AccessDataSource1"  runat="server" DataFile="~/App_Data/mydatabase.mdb"

They told my I can save my html or aspx files in this directory


/USER/WWWROOT


Now my website doesn't work because I have to change my database path to point directly to the /USER/DB , I tried to modify it like this ,

<asp:AccessDataSource ID="AccessDataSource1"  runat="server" DataFile="../DB/mydatabase.mdb"

but it didn't work !

[mendhak]

Modify your AccessDataSource object's DataFile property in the codebehind, where you can use Server.MapPath("../DB/mydatabase.mdb")