linked view from database, Can append but not refresh- help? Mandy 12/31/2008 1:36:01 PM I have a database which is linked to another and provides a view. The view is then imported to a table by an append query. I need to be able to refresh the data in the table as it changes. I have tried an update query and also the refresh data option but neither works. Can anyone help?

Re: linked view from database, Can append but not refresh- help? ghetto_banjo <adam.vogg[ at ]gmail.com> 12/31/2008 3:45:16 PM i know access doesnt like doing updates from a linked table. You could try running a delete query and then re-appending the table in its entirety. Not sure if that is the smartest way to go about it or not. If the append query isnt too complex, it should be reasonably quick.