I'am using a ADO to access the database and when I use the statement/command to insert a record like this;

oRS = oCon.Execute("Insert Into Sample (Name, BDate, TranDate) Values ('Name', '01/20/1975', '')")

then when I view that record the TranDate has a value of 01/01/1900 how can I control that I want the TranDate to be empty not 01/01/1900.

Is there a way that an empty date should store an empty date instead of 01/01/1900?