Advanced SQL Generation Options dimmed

  • Thread starter Thread starter Monty
  • Start date Start date
M

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using advanced datagrid update options wizard 2
Access 2003 and SQL Server 2005 and DAO recordset 1
LinQ. update column with auto generated value 3
.net table adapter code behind missing UPDATE statement 2
You must use the dbSeeChanges option with Open Recordset whenaccessing a SQL Server table that has a 1
too few parameters in SQL statement (expected 1) 2
must use dbSeeChanges option with Recordset 5
DataAdapter no longer generates in vs 2005 1

Back
Top