![]() |
|
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
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 |