Hi, I get the following error when I run the SQL statement below. It works fine on NT4 but when I try it on my Win2k Server, it produces an error. If I run a simple "SELECT *" statement in place of what is below, it executes and returns a valid recordset. I cant figure out what is wrong. I&#039m using an Access 2k database file. I don&#039t have the Access2k app installed on my Win2kServer. I don&#039t see why that would be a problem since all my other db calls execute properly...so far. still testing. The SQL statement is below the error msg. Thanks.<BR><BR><BR>""""""""""""""""""""""""""""""" """"""""""""<BR>HTTP 500.100 - Internal Server Error - ASP error<BR>Internet Information Services<BR><BR>----------------------------------------------<BR><BR>Technical Information (for support personnel)<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)<BR>[Microsoft][ODBC Microsoft Access Driver] Too few parameters.<BR>Expected 2.<BR>/*****/scripts/functions.asp, line 68<BR><BR>Browser Type:<BR>Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) <BR><BR>Page:<BR>GET /*****/default.asp <BR><BR>Time:<BR>Monday, January 1, 2001, 10:42:59 PM<BR>"""""""""""""""""""""""""""""""""""""""""""< BR><BR>----------------------------------------------------<BR>"<BR>SELECT tblAlbumLists.AlbumID, tblAlbumLists.ListID, tblAlbumLists.MemberID, tblAlbumLists.ListOrder, tblAlbums.Album_Title<BR>FROM tblListNames INNER JOIN (tblAlbums INNER JOIN tblAlbumLists ON tblAlbums.AlbumID = tblAlbumLists.AlbumID) ON (tblListNames.ListID = tblAlbumLists.ListID) AND (tblListNames.ListID = tblAlbumLists.ListID)<BR>WHERE (((tblAlbumLists.ListID)=1) AND ((tblAlbumLists.MemberID)=1))<BR>ORDER BY tblAlbumLists.ListOrder;"<BR><BR>objRS_t10.Open strSQL_t10, strConnect, adOpenStatic, adLockReadOnly, adCmdText<BR><BR><BR>THANKS<BR>L.D.L.<BR>tension7@ yahoo.com