MS Access with ASP??

Question

How to connect and handle a access data base with asp???
from where i can get the sourece codes..?

Answer 1

For Some reason, it will not display the code correctly. Email me and I will send it to you, unless this is enough.

OK, did this once before, then I abandoned it for PHP and MySQL. Here was my code:

dim objConn
Set objConn =
Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=MyDatabase.mdb"

dim objRS
Set objRS = Server.CreateObject ("ADODB.Recordset")
objRS.Open "MyTable", objConn, , , adCmdTable

// Replace "MyDatabase.mdb" and "MyTable" with the Access Database name and the Table name.

the line that has ADODB Conn... should say
("ADODB.Connection")

Hope this helps.

Answer 2

Learnasp.com is your best bet for classic ASP programming.

Answer 3

Bewteen vbscripts tags you would use ADO:


Dim cnAccess
Dim recAccess
Set recAccess = CreateObject("ADODB.recordset")
Set cnAccess = CreateObject("ADODB.connection")
cnAccess.Open "Driver= {Microsoft Access Driver (*.mdb)};DBQ=" & MDB_PATH & " ;"
Set recAccess = cnAccess.Execute("select count(*) from " & Table_Name & ";")

Hope this helps...

Answer 4

You can get examples of various ODBC and OLE-DB connection strings at http://www.connectionstrings.com