Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KenRob
Starting Member
1 Post |
 Posted - 2014-07-28 : 15:33:15
|
| Hello all!I have an Access front end linked to a SQL Server 2008R2 database. I am having a lot of trouble with the time field. I have a few time data type fields in a few tables. I have chosen the time(0) data type in SQL server, but whenever I attempt to add test data to the time fields via the Microsoft Access front end, I receive an error stating, "Invalid character value for cast specification." Has anyone had a similar issue? Any advice?Thanks!!Ken |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-28 : 15:41:46
|
| Show us some sample data that you are trying to insert into the time column.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Time Data Type, SQL Server Versus M Access, Access