Saving Record using Access FE to SQL BE

[Blane via AccessMonster.com]

I'm using Access 2003 on the front end and SQL 2000 on the backend. When I
click on a button on the front end form to save a newly created record,
what's the coding to save that record to the SQL server table? The form
source is linked to the sql table.

Thanks for your help,
Blane

 

[Douglas J. Steele]

If you've created linked tables to SQL Server and are binding the linked
tables to your forms, you don't need to do anything to save the data: it'll
automatically be saved when you move to another record, just as it does when
you're using Jet tables (i.e. an MDB file)

If that's not what you're experiencing, you may have to give more details
about how your application is set up.