Update query against SQL table

  • Thread starter Thread starter tim fortin
  • Start date Start date
T

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?
 
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>
 
Presumably you've also got primary keys defined for the SQL Server tables,
since they're not updatable from Access without those.
 
Back
Top