Update query annex passtrough
in [Help]
|
Prev: Creating Charts / Graphs in MS Access 2007
Next: Use of Sharepoint 2010 and Access 2010 - Interesting answers regarding Security and who can make changes
From: Daedalus on 8 Jan 2010 14:08 Hi All I need to update a 'local' table with a value coming from a SQLServer-table accessed via a passtrough-query. So I join my 'local' table with a passtrough-query. As long as it's a select-query 'everything' works, but the prob is the query is not updateble, and of course so is my update-query. I'm on WinXP with Access2003. Any suggestions ? Tanx already ! D
From: Rich P on 8 Jan 2010 16:32 Are you trying to update the sql server table? or the Access table? Rich *** Sent via Developersdex http://www.developersdex.com ***
From: Daedalus on 10 Jan 2010 11:39 "Rich P" <rpng123(a)aol.com> schreef in bericht news:4b47a454$0$87064$815e3792(a)news.qwest.net... > Are you trying to update the sql server table? or the Access table? > > Rich > > *** Sent via Developersdex http://www.developersdex.com *** The Access-table, with info coming from the SQL-table. Not all usedrs hav e access to the sql-server, so I'd like to 'cache' some info
From: Roger on 11 Jan 2010 06:59
On Jan 10, 9:39 am, "Daedalus" <fdproje...(a)hotmail.com> wrote: > "Rich P" <rpng...(a)aol.com> schreef in berichtnews:4b47a454$0$87064$815e3792(a)news.qwest.net... > > > Are you trying to update the sql server table? or the Access table? > > > Rich > > > *** Sent via Developersdexhttp://www.developersdex.com*** > > The Access-table, with info coming from the SQL-table. Not all usedrs hav e > access to the sql-server, so I'd like to 'cache' some info by definition JET has no way of tracking locking information for passthrough queries so they are not updatable either create a JET query, or a sql server view |