Access Project column refresh

  • Thread starter Thread starter Sebastian Schaetz
  • Start date Start date
S

Sebastian Schaetz

Hi.

I have a quite bothering problem with Access 2003 and a SQL Server.
I created a form where the user is able to pick which colums he wants to
have in his query. The form then performs an "Alter View" command on a
given view. After altering the view a macro is executed which exports
the data of the view into an Excel Table.
My problem now is that Access doesn't realize that the columns of the
view were altered. If you do it twice it will show the rows of the
first alteration but the data of the new one. Also if I access the view
via Access directly it won't show the altered tables. The view is
correctly stored in the database - the alter procedure works correct but
Access doesn't seem to get it..

Is there any way to tell Access that the Colums were altered and it
should refetch them or something?


Thanks in advance


Sebastian Schaetz
 
Try refreshing the linked table. I am assuming that you have linked to the view
 
Back
Top