ASP connection to the Access database in several ways!

1.
Set Dbconnection=server.createobject ("ADODB. CONNECTION ")
DBPath = Server.MapPath ("Customer.mdb")
DbConnection. Open "Driver={microsoft Access driver (*.mdb)};d bq=" & DBPath
Sql= "SELECT * from auth where id= '" & user_id & "'"
SET uplist=dbconnection. EXECUTE (SQL)
2.
Set Dbconnection=server.createobject ("ADODB. Connection ")
DBPath = Server.MapPath ("Customer.mdb")
DbConnection. Open "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" &dbpath
Sql= "SELECT * from auth where id= '" & user_id & "'"
SET uplist=dbconnection. EXECUTE (SQL)
3.
DBPath = Server.MapPath ("Customer.mdb")
Set session ("RS") =server.createobject ("ADODB"). Recordset ")
' Rs=server.createobject (ADODB. Recordset ")
Connstr= "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" &dbpath
Sql= "SELECT * from auth where id= '" & user_id & "'"
Session ("RS"). Open sql,connstr,1,3
4.
Build ODBC source XXX
Set Conn=server.createobject ("Adodb.connection")
Conn.Open "DSN=XXX; uid=; pwd=;D Atabase=customer