Access web site database

[Tony]

VS 2002/xp pro/win forms
I want to access an Access database on my website from windows forms.
Can this be done?
I tried several different ways for the path but can't seem to get it,
sometimes creating an error "URI not supported"

I tried
Dim cnString As OleDbConnection = New
OleDbConnection("Provider=MicroSoft.Jet.OLEDB.4.0; Data source=
http://www.mywebsite/fpdb/myfile.mdb"

Dim cnString As OleDbConnection = New
OleDbConnection("Provider=MicroSoft.Jet.OLEDB.4.0; Data source=" &
Server.MapPath("\fpdb\Myfile.mdb"))

Dim cnString As OleDbConnection = New
OleDbConnection("Provider=MicroSoft.Jet.OLEDB.4.0; Data source=
//www.mywebsite/fpdb/myfile.mdb"



None seem to work.

this is the error message I'm getting from
adtp.SelectCommand.Connection.Open()

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred
in system.data.dll


Thanks

 

[Miha Markic [MVP C#]]

Hi Tony,

Is this the same machine you are talking about?
Also, check this thread:
http://groups.google.com/groups?hl=...ernet&safe=images&ie=UTF-8&oe=UTF-8&lr=&hl=en