Properties of QueryTable Object

[Guest]

Hi All
I'd be glad if someone will tell me what do following properties of QueryTable object Denote
1) TablesOnlyFromHTM
2) RefershBackgroundQuer
3) HasAutoForma

Also, I am unable to understand what exactly does Background Query property do

I am trying to pick up the data from Access through SQL Query by ODBC
Thanks

 

[Tom Ogilvy]

if you do a background query, then your code continues to execute - it
doesn't wait for the query to finish.

If you have set an autoformat for the table, then HasAutoformat would be
true.

TablesOnlyFromHTML would have to do with a web query. It would only bring
back tables in the html page I would imagine. If you select these in the
object browser and hit F1, you should get the help screen for the
properties.

 

[Guest]

Thanks for the help Tom !