February 13, 2004 at 3:09 pm
I have a number of places in my MS Access 2002 app where a time only is entered. I would like to use the SQL server smalldatetime as it offers enough precision.
If a user enters "13:00" in the field, Access supplies the date 12/30/1899 and an overflow error occurs because this is just outside the smalldatetime range (starts 1/1/1900). (PS: Why did microsoft do this?!)
To get around the issue, I can put code every place the time field occurs and simply add 2 days to the user's entry. Seems a little annoying to me. Are there any other ideas?
SMK
February 14, 2004 at 5:20 am
Little bit confused.
Are u developing one code which can use both access and sql?
My Blog:
February 14, 2004 at 7:36 am
I have a MS Access 2002 frontend linked to a SQL server 2k backend. Data entry is done from form in Access.
HTH,
SMK
February 15, 2004 at 10:54 pm
What about DTS. I think it is handlening it
My Blog:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply