Linked Table Problems

[Tom Collins]

I have a problem with some of my linked tables. I can't edit some of them.
The source is SQL Server. All the tables are linked the exact same way
through code.

I actually have 2 sets of the backend. An older one that the DBA created,
and a newer one I created. They're both set to allow me to connect based on
my network login ID.

The older one will allow me to make any changes to the data on any table.
The newer one will allow edits on some tables only.

This is only true in the linked tables. In SQL Server Enterprise, I can edit
anything in any table in either backend. I also have not been able to see
any pattern on which tables I can edit and which ones I can't.

Any ideas?

Tom Collins

 

[Dirk Goldgar]

I have a problem with some of my linked tables. I can't edit some of
them. The source is SQL Server. All the tables are linked the exact
same way through code.

I actually have 2 sets of the backend. An older one that the DBA
created, and a newer one I created. They're both set to allow me to
connect based on my network login ID.

The older one will allow me to make any changes to the data on any
table. The newer one will allow edits on some tables only.

This is only true in the linked tables. In SQL Server Enterprise, I
can edit anything in any table in either backend. I also have not
been able to see any pattern on which tables I can edit and which
ones I can't.

Any ideas?

Make sure each of those tables has a primary key field. It may also
help to have a timestamp or rowversion field.

 

[Tom Collins]

That was it. See that's why I only play a DBA on TV.

Thanks!