=> Invalid character value for cast specification

[Rhonda Fischer]

Hello,

I am attempting to save a time of 10:30 in my
Access Project to an SQL table column of type
smalldatetime and the error I receive is:

Invalid character value for cast specification

Is there a way of dealing with time separate from
date?

Your thoughts would be greatly appreciated.

Thank you kindly
Rhonda

 

[Duane Hookom]

You might want to check the range of date values that can be stored in a
SmallDateTime field.