Advanced SQL Generation Options dimmed

[Monty]

I'm having trouble updating records. I get an error saying my update
command has not been set. I realize I need to enable both options in the
"Advanced SQL Generation Options" screen, but these options are dimmed such
that I cannot select them. Any help please. Thank you, Mark

[Monty]

Upon further research, I've answered my own question... So if others are
interested, here is why it won't work.
"Refreshing the data table is only supported on databases that support
batching of SQL statements. For example, Microsoft Access cannot refresh the
data table in the same command that performs other operations."

Thank you, Mark

"Monty" <mo***@chartered.net> wrote in message
news:WK*************@fe07.lga...

I'm having trouble updating records. I get an error saying my update
command has not been set. I realize I need to enable both options in the
"Advanced SQL Generation Options" screen, but these options are dimmed
such that I cannot select them. Any help please. Thank you, Mark