Data Entry Error(s)

[Datahead2010]

I have an Access Front End, A SQL Server 2005 backend. I have one table (Main) one field set to "nchar(12) ", ("default vale is set to "0" ). I link via an ODBC driver. When I go to the field and try to enter "123456789012" It stops me anywhere from the first character to the six character and will not let me enter all twevle values. If I close the table, and reopen I can complete the entry, However, if I move to another record same issue. What gives? I am doing this from a table just opened. less than 5000 records! ( I have another field with just four characters, same type of problem. )

 

[boblarson]

Why is the datatype set to nchar and not nvarchar? You can limit the number of characters in other ways instead of using nchar. Also, 0 as a default for nchar(12) is an incorrect default.

 

[boblarson]

Also, are you using the SQL Native Client driver instead of the normal SQL Server driver if your machine is WinXP or earlier?

 

[Datahead2010]

Bob Larson, What is the correct default value? What is it for nvarchar? ( I am using the SQL server driver in the ODBC connection list ) Thanks for the information.

 

[boblarson]

You are okay with 0 for nvarchar but I wouldn't want to guess with an nchar.

 

[Datahead2010]

Changed data types, refreshed SQL DB, refreshed Access link.... Same issue.