Creating web-links

[BoroLee]

I have a d/b which is full of students names etc etc. i want to send them an e-mail asking if they wish to register for on-line invoices and payments.

i need to know how i can create a web-link in the e-mail, so that the student can click this link, and the "Interested" box in my d/b would then be filled with a "y".

Any advice is much appreciated. This is my 1st attempt at web stuff.

Lee.

 

[Kevin_S]

The two most common ways to skin this cat are:

(1) - create a dap and put it on the web - the dap (a web access form) will then update your table as required. The pros to using this method is that it is fairly simple to create a simple dap and move it to a web page for access and the development time (because its fairly simple) is not very long. The cons to this method is that daps are more of a "throw in" by Microsoft are are not very flexible at all.

(2) - use ASP (or similar web tools) to create the web form and then use ADO to transfer response to your db. The pros to this method is that asp pages (and the like) are very flexible, can be as fancy or as simple as you want, flexible, and more developer friendly. The cons to this method are that the understanding to use this method may be a deterant as a solid understand of asp, ado (ado.net), and xml are usefull (if not required)...

No matter which method you chose you can find lots of information on both by searching this forum for "data access pages, dap) or (active server pages, asp, web forms) etc...


HTH,
Kev