Update query against SQL table

[tim fortin]

With a form linked to a SQL table instead of an ACCESS
table, how can changes made to data elements on the screen
be saved to the SQL table?

 

[Jeff Boyce]

Tim

Is that a theoretical question, or are you having trouble? When I link to a
SQL table, then bind a form to that SQL table, changes in the controls on
the form change the underlying SQL data.

Of course, I have to have permissions (from the SQL side) to change the
data...

Good luck

Jeff Boyce
<Access MVP>

 

[Douglas J. Steele]

Presumably you've also got primary keys defined for the SQL Server tables,
since they're not updatable from Access without those.