=> Invalid character value for cast specification

  • Thread starter Thread starter Rhonda Fischer
  • Start date Start date
R

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
 
You might want to check the range of date values that can be stored in a
SmallDateTime field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CAST function question 3
Unable to create table using Access 97 3
Invalid Character Error when i "refresh data" 7
add a value to a date 8
Parse text string and insert characters 5
Q on Entering a Criteria within a Query 1
LINQ Issue - "Specified cast is not valid" 4
Invalid cast from System.Int32 to System.Byte[]. 1

Back
Top