title: Using Access to change SQL tables. Table randomly becomes read-only
body: <p>I have a database that the client needs to update. They like to use access. Some tables randomly become read-only for them. Any ideas why?</p>
  
  <p>They are using Access 2007 and MS SQL 2005.</p>
  
  <p>SQL Table:</p>
  
  <pre><code>CREATE TABLE [dbo].[Users](
      [SyncGroup] [varchar](20) NULL,
      [UserID] [varchar](20) NOT NULL,
      [Password] [varchar](20)  NOT NULL,
      [Restriction] [text] NULL DEFAULT (' '),
      [SiteCode] [varchar](20) NULL,
      [Group] [varchar](20)  NULL,
      [EmpId] [varchar](20)  NULL,
      [TimeZoneOffset] [int] NULL,
      [UseDaylightSavings] [bit] NULL,
      PRIMARY KEY ([UserID]) )
  </code></pre>