Need help connecting to Access database on website.

[Techwarrior]

I have an Access database stored on my website in the following location:

http://www.mysite.com/db/test.mdb.

I am trying to connect to it in my web.config file with the following code:
<connectionStrings>
<add name="testdbConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=//

http://www.mysite.com/db/test.mdb;Jet

OLEDB:System Database=system.mdw;uid=myid;password=mypassword"
providerName="System.Data.OleDb" />
</connectionStrings>

Everytime I try to access it with my webpage I get the following message:"It is already opened exclusively by another user, or you need permission to view its data."

Can anyone help me?

 

[ca8msm]

You'll need to specify the physical path to the database rather than the web address.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.