Surprising problem with View in adp 2003

• Paul Sp

  SSCrazy

  Points: 2314

  More actions

  September 21, 2005 at 10:34 am

  #67481

  Hi

  I've included this in both the Access Forum and SQL forum as I'm not sure where it belongs.  I have an Access 2003 .adp which has problems caused by views:

  Something has happened several times which has surprised me greatly.  I have many views with fields from several joined tables.  If I add say two fields to a table showing all fields (*) in a view, the results are:

  a) The two new fields do not automatically show in the view

  b) All the data is moved along by two columns.

  The only way I can correct this is to copy the sql to a new view.  This immediately rectifies the situation.

  It appears that I need a way to automatially refresh the view??

  Can anybody suggest what I should do?

  Thanks

  Paul

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 21, 2005 at 11:33 am

  #591920

  Please do not cross-post, we monitor all boards.

  Finish the thread here :

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=222242