Connect to Web Database

[tready]

I have an ASP application with a MS Access backend. I want to create an app that can connect to that database. Is this possible and if so can someone show me what the connection string would look like??

 

[IfYouSaySo]

Not sure, but I bet you find your answer here:

www.connectionstrings.com

 

[rockwell]

not sure about asp but in vb.net u do this way


Imports System.Data.OleDb
Dim Myconn As OleDbConnection
Dim cmd As OleDbCommand
Dim cmd1 As OleDbCommand
Dim rec As OleDbDataReader

Myconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;")
Myconn.Open()
Myconn.close()

--kris

 

[shroomy]

If i understand you correctly you want a remote user to have access to the MS Access db your asp pages are using.

the only two ways I can think to do that would be via a webservice that you could pass a SQL string into and return a dataset.

Or do the same sort of thing with remoting

but no matter what you decide to do, be very very carefull about security.
You are opening yourself up quite a bit.