selecting a sub query in autoit?

[tn04462]

i been trying to select a query in my script because it contains the modified version of the description from ms database but I can't run the query for some reason.

the query name : sub-desc2 - i've tried with and without brackets []

the field is: 8el

#include <access.au3>

$adSource = "data.accdb"

$oADO = _dbOpen($adSource)

$sQuery="select * from sub-desc2"

$result= $oADO.Execute($sQuery)

MsgBox(0,"",$result.Fields( "8el" ).Value )

$result= $oADO.Execute($sQuery)^error

Edited April 28, 2012 by tn04462

[tn04462]

>"C:Program Files (x86)AutoIt3SciTE..autoit3.exe" /ErrorStdOut "C:Scriptsturbolisterpulldesc.au3"

We intercepted a COM Error!!

err.description is: Syntax error in FROM clause.

err.windescription is:

err.lastdllerror is: 0

err.scriptline is: 7

err.number is: 80020009

err.source is: Microsoft Office Access Database Engine

err.helpfile is:

err.helpcontext is: 5003131

C:Scriptsturbolisterpulldesc.au3 (8) : ==> Object referenced outside a "With" statement.:

MsgBox(0,"",$result.Fields( "8el" ).Value )

MsgBox(0,"",$result.Fields( "8el" )^ ERROR

>Exit code: 1 Time: 2.942

[tn04462]

is it possible to select a subquery? i can't find any post that had an example . any help please?