title: Schema changes not updated in MS Access front end linked to the database
body: <p>I created a new table in SQL server using SQL Server Management Studio but the MS Access front end linked to the database was not updated.</p>
  
  <p>I tried reopening Access but still the new tables cannot be found. Yet when I check the SQL Server database they are there.  </p>
  
  <p>My tables in Access are linked to the database so <em>I assumed any table or changes made in the SQL server database would be reflected in the Access front end</em>.  When I run a query in Access looking for the tables nothing is found.  Another bit of information is when I right click and press view dependencies it says unable to view dependencies because </p>
  
  <blockquote>
    <p>"unable to cast object of type 'System.DBNull' to type
    'System.string'"</p>
  </blockquote>
  
  <p>Something is maybe wrong with the way i save the query but I am not sure.</p>