Hi,

I hope you can help me with this.



I am trying to use a secured database.



I am using DSN connection, thie is my Code



<%

Dim objConn

Dim objRec

Dim SearchFor



Session("UserID")=Request.Form("EmpID")

Session("PassWord")=Request.Form("PassWord")



SearchFor = Session("UserID")

SearchFor = "UserName="&"'"&SearchFor&"'"



Set objConn = Server.CreateObject ("ADODB.Connection")

Set objRec = Server.CreateObject ("ADODB.Recordset")



objConn.open "DSN=TRAN3","Admin","" 

objRec.Open "WebUsers", objConn, 1,3,2   <<<<< this is line 34



objRec.Find SearchFor

.......

%>



I get this error:



Microsoft OLE DB Provider for ODBC Drivers error '80040e37' 



[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet

database

engine cannot find the input table or query 'WebUsers'. Make sure

it

exists and that its name is spelled correctly.



/trainingIV/CheckPW.asp, line 34 



I used the database without the user security, and it works.



What am i doing wrong?



Am I suppling the User_Name and Password correctly?



The DSN is pointing to the workgroup file.



Thank you for your help.