SQL View Help

[doodle]

Greetings. Access 97, SQL Server 2005.

I am in the process of moving the back end of my db to sql. i moved
the data and have changed some of my queries over to views on the
server. i then linked the views just as i linked the sql tables, then
referenced them in my db. this has made things much faster.

however, how do the sql views and tables "refresh"? I noticed that if
i modify a table or a view, the changes do not reflect in access
unless i delete the link and relink to sql.

????

-doodle

 

[Guest]

Hi Doodle,

I noticed that if i modify a table or a view, the changes do not
reflect in access unless i delete the link and relink to sql.

If you are making a design change, you *should* always delete the linked
table or view, and then re-create it from scratch. I recommend doing a
compact and repair as well, after deleting the link, but before creating the
new one. Access tends to cache a lot of information in the link. This can
easily become out-of-date if you make design changes to the underlying object.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[doodle]

Thanks Tom.

-doodle