Last active
April 22, 2016 16:15
-
-
Save NPS-ARCN-CAKN/287465a658248759da7a747a72af17f1 to your computer and use it in GitHub Desktop.
TIME field in SQL Server Table causes ODBC Error in Microsoft Access: ODBC --update on a linked table failed Invalid character value for cast specification
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
I have a Sql Server 2008R2 database with a table with a TIME field in it. I have a Microsoft Access front end with ODBC linked tables. When I try to add or update a database record using a textfield that is bound to the TIME field I got an error: ODBC --update on a linked table failed Invalid character value for cast specification. After tinkering a bit I changed the text field's Input mask property to 'input mask to 00:00:00;0;_' which solved the problem. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment