title: Access linked table to SQL Server: TinyInt incorrect mapping
body: <p>I got a SQL Server PriceLists table:</p>
  
  <pre><code>CREATE TABLE [dbo].[PriceLists](
      [PriceListId] [tinyint] IDENTITY(1,1) NOT NULL,
      [PLName] [varchar](20) NULL,
  CONSTRAINT [PK_PriceLists] PRIMARY KEY NONCLUSTERED 
  </code></pre>
  
  <p>When I link it into Access 2007, Access sets the PriceListId to Long Integer (which is incorrect).<br>
  When I link other tables where the TinyInt is not "AutoNumber" (in Access jargon), it links correctly as a Byte field.<br>
  Any clue about properly attaching the table to have the PriceListId as an AutoNumber, Byte field?</p>