Trouble working with ACESS Database and Date Fields

My problem is two-fold:

(a) How do you clear a populated date filed?

(b)If the user inputs an invalid date and ASP attempts to update the MS Access Database, ASP crashes. Who can I trap thiscondition before the attempt to post?


I am sure I am supplying way to little information. Nonetheless, any assistance would be greatly appreciated!

 

Hi,
What are you using to code these Access data pages? Dreamweaver? (Hope so..)
Anyway...See if this helps a bit:
http://www.w3schools.com/ado/ado_update.asp
Salute,
Mark

 

Mark.

Thank you for your prompt response. First, I am coding my ASP from the keyboard. I am just not a "search men and click" kinda guy.


I am familiar with the link you sent. Let me see if I can restate my problems. If my MS Access database hasone record with a populated date field, how do I clear the field?


Thanks again.

 

It's been a while since I did that with ASP and Access but I think you need to alter the record with a null entry.
Problem is the field may not accept nulls.

You'll do good to pickup a copy of Macromedia Studio on ebay if you can.
You don't need the newer Adobe versions for Classic ASP.
The reason I mention this is, Dreamweaver will create the update code procedures for you.
It does an unreal job of that.

If you need any code samples I can dig them up from my old CD backups.
Salute,
Mark

 

Ok, I will fess up, I have the Macromedia MX Suite. I will try to figure out how to use it to generate the needed code. Please stand by incase I get stuck (lol)!

Hope I can figure this out! THanks again.