[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

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?

Many Thanks,
0
Jinghui Li
Asked:
Jinghui Li
2 Solutions
 
dportasCommented:
Does the table have a key? I don't think Access will allow you to update it otherwise.

Access Data Projects (ADPs) are a legacy technology that Microsoft no longer supports. They are probably best avoided.
0
 
Jinghui LiAuthor Commented:
Yes. it has the primary key.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now