Can we make 2, 3 or 4 connections on the same data file with diffirent tables name. If yes how do we make that happend..<BR><BR>i did that and wath should be next ? copy paste ?? i try that but didnt work.<BR><BR>&#039;=============================== ==================================<BR>&#039;Create an ADO connection odject<BR>Set adoCon = Server.CreateObject("ADODB.Connection")<BR><BR>&#0 39;Set an active connection to the Connection object using a DSN-less connection<BR>adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Membres.mdb")<BR><BR>&#039;Set an active connection to the Connection object using DSN connection<BR>&#039;adoCon.Open "DSN=guestbook"<BR><BR>&#039;Create an ADO recordset object<BR>Set Configuration = Server.CreateObject("ADODB.Recordset")<BR><BR>&#03 9;Initialise the strSQL variable with an SQL statement to query the database<BR>strSQL = "SELECT tblMembres.* FROM tblMembres WHERE user_ID=" & lngRecordNo <BR>strSQL = "SELECT Configurations.* FROM Configurations;"<BR><BR>&#039;Open the recordset with the SQL query <BR>Configuration.Open strSQL, adoCon<BR>&#039;================================== ==================================