select unique field when linking to a sqlserver view by code "Dan Goldman" <dz801[ at ]yahoo.com> 11/2/2008 7:10:21 AM When manually creating a linked table whose source table is a sqlserver view, Access prompts for the unique field, without which the linked table isn't updatable. I need to create such updatable linked tables by code (with CreateTableDef). Access doesn't allow adding indexes to linked tables, so my tables are read-only. Is there a solution? TIA Dan

Re: select unique field when linking to a sqlserver view by code "Dan Goldman" <dz801[ at ]yahoo.com> 11/2/2008 7:19:25 AM found the solution: http://support.microsoft.com/kb/q209123/ Dan "Dan Goldman" <dz801[ at ]yahoo.com> wrote in message news:%234sqSoLPJHA.1148[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > When manually creating a linked table whose source table is a sqlserver > view, Access prompts for the unique field, without which the linked table > isn't updatable. > > I need to create such updatable linked tables by code (with > CreateTableDef). Access doesn't allow adding indexes to linked tables, so > my tables are read-only. > > Is there a solution? > > TIA > Dan > >

Re: select unique field when linking to a sqlserver view by code "Ray Jefferson" <ray[ at ]databasewhiz.com> 12/21/2008 10:04:44 PM Outstanding! Was cruising newsgroup looking to help and found answer to problem we've had for some time. It was always an issue moving our apps from development to production for our clients, so as part of that process, we would delete and add the views back manually. Alas, a piece of Good News. :) RJ Database Whiz Consulting www.databasewhiz.com "Dan Goldman" <dz801[ at ]yahoo.com> wrote in message news:OK$OXtLPJHA.3936[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] > found the solution: > http://support.microsoft.com/kb/q209123/ > Dan > > > "Dan Goldman" <dz801[ at ]yahoo.com> wrote in message > news:%234sqSoLPJHA.1148[ at ]TK2MSFTNGP05.phx.gbl... >> When manually creating a linked table whose source table is a sqlserver >> view, Access prompts for the unique field, without which the linked table >> isn't updatable. >> >> I need to create such updatable linked tables by code (with >> CreateTableDef). Access doesn't allow adding indexes to linked tables, so >> my tables are read-only. >> >> Is there a solution? >> >> TIA >> Dan >> >> > >