Saving Record using Access FE to SQL BE

  • Thread starter Blane via
  • Start date

Blane via

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,

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.

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