I saw one post on this, but was never replied to. Did anyone come across this error when switching their Access 97 db to 2000. I also switched from using a odbc driver for my connection, to using the &#039Microsoft.Jet.OLEDB.4.0&#039. (see below).<BR><BR>&#039Create Connection & Recordset Objects<BR>Set oConn=Server.CreateObject("ADODB.Connection")<BR>S et rsUsers=Server.CreateObject("ADODB.Recordset")<BR> <BR>&#039New Connection using OLEDB for Access 2000<BR>oConn.Provider = "Microsoft.Jet.OLEDB.4.0"<BR>oConn.Properties("DAT A SOURCE") = server.mappath("ffldb.mdb")<BR> <BR><BR>&#039Set ConnectionString<BR>&#039DSNtemp="PROVIDER=MSDASQL ;"<BR>&#039DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "<BR>&#039DSNtemp=DSNtemp & "DBQ=" & server.mappath("ffldb.mdb")<BR>&#039oConn.Connecti onString = DSNtemp<BR> <BR>&#039Open Connection<BR>oConn.Open<BR> <BR>&#039 Build Properties & Open Recordset<BR>sql = "SELECT * FROM users WHERE user_name = &#039" & trUsername & "&#039;"<BR>rsUsers.Open "users", oConn, adOpenDynamic, adLockOptimistic, adCmdTable<BR><BR>... everything worked fine before. I installed SP5 and MDAC2.1 on the IIS server, but can&#039t get past this problem. Thanks for any help.<BR>