configuring table for asp pages

[ViperD]

I have a couple of questions here and not sure where to post them all so I'm going to start in this forum.

I am trying to code an asp page that will be accessing information from an access database. In the past I've had problems getting the right configuration so that I could insert data from the asp page into the db.

If I have a field in Access that is a date. If I chose simple date (6/7/2004) what format is access expecting to receive the data (06072004 or 6/7/2004, etc)?

 

[PHV]

Try this format: #yyyy-mm-dd#

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244