<div>
I figured out that field is limited to 255 characters. I changed the max characters in SQL, but do I need to restart SQL server?
</div>


I figured out that field is limited to 255 characters. I changed the max characters in SQL, but do I need to restart SQL server?

<div>
<div class="content wysiwyg-content">
We have an application and our developer is out of town until next week. However we have a major problem saving comments in a certain field. <br />
<br />
Yesterday before he left we were getting this error everytime we try to save new comments as seen in the image below. The developer said &quot;this is working now after I refresh the database connection&quot;. Im not sure what this means.<br />
<br />
Today:<br />
In the comments, I can type TEST and save. One user typed “Received payment and mailed out records to office” and it would throw the odbc error. I would remove the word “office”, and it would save. I tried typing just the word office and it would save… real random.<br />
<br />
I have some programming experience and web development experience. Can someone assist me in resolving?
</div>
</div>


We have an application and our developer is out of town until next week. However we have a major problem saving comments in a certain field. 

Yesterday before he left we were getting this error everytime we try to save new comments as seen in the image below. The developer said "this is working now after I refresh the database connection". Im not sure what this means.

Today:
In the comments, I can type TEST and save. One user typed “Received payment and mailed out records to office” and it would throw the odbc error. I would remove the word “office”, and it would save. I tried typing just the word office and it would save… real random.

I have some programming experience and web development experience. Can someone assist me in resolving?

Access error saving comments, odbc sql server driver string or binary data would be truncated

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.