any ideas why a datashape call to an access db (ODBC) gives an error:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. <BR><BR>for the following code- <BR>&#060;%<BR>set conn = Server.CreateObject("ADODB.Connection")<BR> ovider = "MSDataShape"<BR>conn.connectionstring = "DSN=test1"<BR><BR>&#039conn.OpenFromInitializatio nString(L"Provider=MSDataShape.1;Persist Security Info=False;Data Provider=Microsoft.Jet.OLEDB.4.0;DSN = test1") <BR><BR><BR><BR>strSQLshape = "SHAPE { SELECT * FROM question } " & _ <BR> " APPEND({SELECT option_id, option_text, question_id FROM option} AS OPTION " & _<BR> " RELATE question_id TO question_id )"<BR><BR>set questionRS = server.createobject("ADODB.recordset")<BR>question StrSQLshape, conn<BR>%&#062;<BR>Ive tried everything, theres no problem with the syntax, Ive installed ADO 2.5, & it recognises the MSDatashape provider?? <BR><BR>any ideas