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" <TLD (AT) discussions (DOT) microsoft.com> wrote

Thanks for your help, but I don't see the answer to my problem in the article
referenced.

"Jens K. Suessmeyer" wrote:

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: