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

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" <(E-Mail Removed)> wrote in message
news:WK%Xf.21$(E-Mail Removed)...
> 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
>