Records are not editable in MS Access database project

Hi,
I have a MS Access database project which is connect a SQL server database.
There is a table has a column with "char" format. I found this column can't be edit when I open this database in MS Access. But it will be editable if I change the format to "varchar".
Could someone tell me why?

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library. Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…

Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…