I have an application using an Access 2003 project connecting through ADO which must refer to a table in a SQLServer 2000 database other than the main database. When I connect, I get the data but the recordset is not updatable. I can create a view in the main SQLServer database that makes the connection and can be updated, but when I open that view in Access, it's still not updatable. Is there some simple way to update the data?
Hi, http://support.microsoft.com/kb/328828 HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- "TLD" wrote in message news:D6D862E7-D3AB-48EA-92D2-2479620DC822@microsoft.com... >I have an application using an Access 2003 project connecting through ADO > which must refer to a table in a SQLServer 2000 database other than the > main > database. When I connect, I get the data but the recordset is not > updatable. > > I can create a view in the main SQLServer database that makes the > connection > and can be updated, but when I open that view in Access, it's still not > updatable. > > Is there some simple way to update the data? >
Thanks for your help, but I don't see the answer to my problem in the article referenced. "Jens K. Suessmeyer" wrote: > Hi, > > http://support.microsoft.com/kb/328828 > > > HTH, Jens K. Suessmeyer. > > --- > http://www.sqlserver2005.de > --- > > "TLD" wrote in message > news:D6D862E7-D3AB-48EA-92D2-2479620DC822@microsoft.com... > >I have an application using an Access 2003 project connecting through ADO > > which must refer to a table in a SQLServer 2000 database other than the > > main > > database. When I connect, I get the data but the recordset is not > > updatable. > > > > I can create a view in the main SQLServer database that makes the > > connection > > and can be updated, but when I open that view in Access, it's still not > > updatable. > > > > Is there some simple way to update the data? > > >
The problem turned out to be that the "uneditiable" fields were char rather than varchar. When the user put a cursor into the field, he wasn't able to insert letters. Changing the configuration of the underlying table has resolved the problem. Thanks for your help. "Jens K. Suessmeyer" wrote: > Hi, > > http://support.microsoft.com/kb/328828 > > > HTH, Jens K. Suessmeyer. > > --- > http://www.sqlserver2005.de > --- > > "TLD" wrote in message > news:D6D862E7-D3AB-48EA-92D2-2479620DC822@microsoft.com... > >I have an application using an Access 2003 project connecting through ADO > > which must refer to a table in a SQLServer 2000 database other than the > > main > > database. When I connect, I get the data but the recordset is not > > updatable. > > > > I can create a view in the main SQLServer database that makes the > > connection > > and can be updated, but when I open that view in Access, it's still not > > updatable. > > > > Is there some simple way to update the data? > > >
