I keep getting this error. Do you know why? Before everything was working ok. I dont what has gone wrong.<BR>Error Type:<BR>Provider (0x80004005)<BR>Unspecified error<BR>/~KA024/check_user.asp, line 37<BR>and this is line 37:<BR>rsCheckUser.Open strSQL, strCon.<BR><BR>Its simply refering to the code below where a DB is opened a query passed.<BR><BR>&#039;Set an active connection to the Connection object<BR>adoCon.Open strCon<BR><BR><BR>&#039;Create a recordset object<BR>Set rsCheckUser = Server.CreateObject("ADODB.Recordset")<BR><BR>&#03 9;Initalise the strSQL variable with an SQL statement to query the database<BR>strSQL = "SELECT tblUsers.Password,tblUsers.Major,tblUsers.LastName FROM tblUsers WHERE tblUsers.UserID =&#039;" & strUserName & "&#039;"<BR><BR><BR>HElp please. please <BR>