Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Forms

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-03-2006, 09:11 AM
Novice
 
Join Date: Nov 2005
Posts: 4
slash75
Default 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.
Reply With Quote
  #2  
Old 09-06-2008, 12:39 PM
Novice
 
Join Date: Sep 2008
Posts: 1
mattsperandio is on a distinguished road
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating Data Access Page on Intranet? slash75 Access 0 11-14-2008 12:26 PM
How can I automatically copy a record entered in one form to another form kabichan Access 0 11-10-2008 09:32 AM
Is Access support CASE Expression as SQL Server? winwin Queries 0 11-03-2006 11:31 PM
Updating Multiple Pass-Through Queries through a Form ryan05 Access 0 03-19-2006 08:52 PM
How do link a web form to a access db ? Al Programming 0 03-16-2006 03:09 PM


All times are GMT -8. The time now is 02:55 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.