linked view from database, Can append but not refresh- help?

[Mandy]

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?

 

[ghetto_banjo]

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.