470,849 Members | 1,187 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

Advanced SQL Generation Options dimmed

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
Apr 3 '06 #1
1 1633
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

Apr 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Birahim FALL | last post: by
2 posts views Thread by Tim Marshall | last post: by
2 posts views Thread by Jon Paal | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.