title: SQL Server 2008: why do I see only system tables when I login ODBC from ACCESS
body: <p>I am using Access to try to get some links to tables in SQL Server 2008.</p>
  
  <p>I've created a user name under security in SSMS for SQL Server and I've mapped it to a user that is under the database that I need. I've also given that user a default database that I need.</p>
  
  <p>When I try to connect through ODBC I am not seeing the correct tables. What I am seeing is a bunch of <code>Sys</code> tables. Does anyone know what I am doing wrong?</p>
  
  <p>Here is the create for the main user:</p>
  
  <pre><code>/* For security reasons the login is created disabled and with a random password. */
  /****** Object:  Login [lomuser]    Script Date: 10/22/2010 08:14:03 ******/
  CREATE LOGIN [lomuser] WITH PASSWORD=N'µ''ØÑëOº\¾dõMÐàæfÄ%[RríÜ2 y', DEFAULT_DATABASE=[LOMDATABASE], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
  GO
  
  ALTER LOGIN [lomuser] DISABLE
  GO
  </code></pre>
  
  <p>Here is the create for the specific user to the specific database (on which the top user is mapped to) also FYI they have the same name:</p>
  
  <pre><code>USE [LOMDATABASE]
  GO
  
  CREATE USER [lomuser] FOR LOGIN [lomuser] WITH DEFAULT_SCHEMA=[dbo]
  GO
  </code></pre>