Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Updating SQL server form Access form?

    I have an access form. I want to add a submit button to the form that when clicked runs a sql insert statement that gets inserted into a SQL Server table. I will be connecting to the SQL server through an IP address similiar to how you would on an .asp page. Can anyone explain to me how to do this or show me some example code? I don't know how to make this happen in access.

  2. #2
    Join Date
    Sep 2008
    And if anybody, how do I link my sql server database and my access together ? Access has a tool that links tables, etc ... But how if a table resides in a SQL server ? Can Anybody ? thks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Updating Data Access Page on Intranet?
    By slash75 in forum Access
    Replies: 0
    Last Post: 11-14-2008, 03:26 PM
  2. Replies: 0
    Last Post: 11-10-2008, 12:32 PM
  3. Replies: 0
    Last Post: 11-04-2006, 02:31 AM
  4. Replies: 0
    Last Post: 03-19-2006, 11:52 PM
  5. How do link a web form to a access db ?
    By Al in forum Programming
    Replies: 0
    Last Post: 03-16-2006, 06:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums