Ok...hum...I got a weird problem here and maybe some Access pro will know that.<BR><BR>I have this function.... :<BR><BR>..is the color ok ? :p<BR><BR>Function RunQuery(Byval prmstrSQL)<BR>Dim strConn<BR>Dim objConn<BR>Dim objRS<BR><BR>strConn = "Driver={Microsoft Access Driver (*.mdb)};" & _ <BR> "Dbq=" & Server.MapPath("./data") & "stephanedorion.mdb;" & _<BR> "Uid=admin;" & _<BR> "Pwd=eniac"<BR><BR>&#039;strConn = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;" & _ <BR>&#039; "DATA SOURCE=" & Server.MapPath("./data") & "stephanedorion.mdb;" & _<BR>&#039; "Uid=admin;" & _<BR>&#039; "Pwd=eniac"<BR><BR><BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>With objConn<BR> .CursorLocation = adUseClient<BR> .Open strConn<BR>End With<BR><BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>With objRS<BR> .CursorLocation = adUseClient<BR> .CursorType = adOpenKeyset<BR> .LockType = adLockOptimistic<BR> .Open prmstrSQL, objConn<BR> Set .ActiveConnection = Nothing<BR>End With<BR><BR>Set RunQuery = objRS<BR><BR>&#039;Not closing because it will affect the RS returned by RunQuery<BR>&#039;Needs to be done by the page calling the function<BR>Set objRS = Nothing<BR><BR>objConn.Close<BR>Set objConn = Nothing<BR><BR>End Function<BR><BR><BR>When using this function I can make the following SQL <BR>"SELECT * FROM Menu"<BR><BR>I get the result, everything is fine,<BR><BR>But if I run this : <BR><BR>SELECT Menu.MenuID, Menu.AppearOrder, Menu.MenuE, SubMenu.SubMenuID, SubMenu.SubMenuE FROM Menu LEFT JOIN SubMenu ON Menu.MenuID = SubMenu.MenuID ORDER BY Menu.AppearOrder, SubMenu.SubMenuE<BR><BR><BR>Function BuildMenu()<BR>Dim strSQL<BR>Dim objMenuRS<BR>Dim objString<BR><BR>strSQL = "SELECT Menu.MenuID, Menu.AppearOrder, Menu.MenuE, SubMenu.SubMenuID, SubMenu.SubMenuE " & _<BR> "FROM Menu LEFT JOIN SubMenu ON Menu.MenuID = SubMenu.MenuID " & _<BR> "ORDER BY Menu.AppearOrder, SubMenu.SubMenuE"<BR>Set objMenuRS = RunQuery(strSQL)<BR><BR>If Not objMenuRS.EOF Then<BR> Set objString = New clsString<BR> With objString<BR> Do<BR> .Add objMenuRS("MenuE")<BR> objMenuRS.MoveNext<BR> Loop Until objMenuRS.EOF<BR> End With<BR> objMenuRS.Close<BR>End If<BR>Set objMenuRS = Nothing<BR><BR>Set BuildMenu = objString.value<BR>Set objString = Nothing<BR>End Function<BR><BR><BR>I get no results...no errors...but no results. I ran the query in access and it works fine so...hum...why is my SQL isn&#039;t working??<BR><BR>some kind of unsupported feature by the driver like the left join ??<BR><BR>Thanks<BR><BR>Eniac