How to connect to a remote MS Access database using ASP

[kishore22]

Hi guys,
I need to insert some data into MS Access database using ASP.

I need the steps to connect to the remote MS Access database.

Thanx

 

[Preston5]

This is what I use and it always works. The key thing is setting up your ODBC/DSN connection string on the server, then using the ASP to call that string.

Dim myConn
Dim strNaDB

Set myFSO=CreateObject("Scripting.FileSystemObject&quot
Const ForReading = 1, ForWriting = 2, ForAppending = 8

'Build the Dataset Connection String
strPathToMDB="\\ospsdev1\AccessData\AssociateSetup.mdb"
myConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strPathToMDB & ";User Id=dt23782;Password=dt23782; "
Set myConn=Server.CreateObject("ADODB.Connection&quot
strNaDB="DSN=NewAssociate123"
myConn.Open strNaDB