Update Query w/ write access to only one table

[BFreshour]

I have a linked table that I'd like to pull data from and place into a local table. I only have view rights on the linked table. I tried multiple times to create a Update query which would pull the data off the linked table and place it into the local table. I was never successful, each time recieving the error message:

Operation must use an updateable query

I've searched high and low for a way to do this. I'm running Access XP and my linked tabled is a SQL table. I thought I might be able to right some VBA code to retrieve the records and manually put them into the table, but I don't know enough VB code to do this.

Any help would be greatly appreciated...

 

[RobCPA]

You'll want to stick with SQL update query rather than VBA. It's just a matter of setting up the queries appropriately. FMS wrote a white paper on this subject at:

http://www.fmsinc.com/tpapers/nonupdat/index.html