Chris, You said, "Perhaps you can take a step back and describe the whole process?" OK.
Page 1 collects firstname, lastname, email and sends the data via POST to page2.
Page 2 ASP checks the data for prior entry in the database, creates an appropriate nickname and the fullname, creates a...
OK. It can't be done. What about the "on click" facility? - - - Is it possible to use it to get a piece of ASP code to run so that the database insert would happen between the submit button being clicked and the form action taking place?
You do this in the Internet Information Services on the web server. Select the web site, right click it and choose Properties. In there, you want the 'Documents' tab. That will allow you to add your index page name to the list and, if you want, move it to the top of the list.
The page contains code that writes a record to the database using data from a form on the previous page. The process requires that the user clicks [Continue] so that the next part of the process gets done. I need to prevent exit from this page by any means except the [Continue] button. How...
In Enterprise Manager, Security, Linked Servers:
Add a new one:
Name: BIG2 (different host on same LAN)
Product name: OLE DB Provider for Jet
Data Source: D:\SALES\PRIVATE\EMMS.MDB
Provider string: Microsoft.Jet.OLEDB.4.0
I then get icons for tables and views. Double-click...
OK guys. I've done some reading as you suggest. But it seems from what I've read that the Access DB has to be on the same server as the SQL DB if I want to add records to it.
Have I misunderstood?
Hi Gurus, This is what I want to happen when I programmatically change the value of a logical field in SQL:
1. There's a trigger that runs a stored procedure.
2. The stored procedure creates a new record in a table in MS Access that is running on a different host.
The SQL is MS SQL Server...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.