New Record Disabled on Linked Table

N

Nick C.

Hi, I would like to add a new reocrd to a linked table while in the datasheet
view. I setup a system DSN using a sql login that I know can perform
updates. My question is that I'm not sure where or how to verify that
security is operating properly and hence why I'm having these problems..

Any guidance would be appreciated.

Thanks,

- Nick
 
B

Brendan Reynolds

Does the table have a primary key or other unique index or constraint?
ODBC-linked tables without a unique index or constraint are read-only.
 
N

Nick C.

Hi Brendan,

The table in question does have a primary key defined against an identity
field.

- Nick
 
B

Brendan Reynolds

Then it probably is a security issue. You say you're logging in as a user
that you know can perform updates, but are you sure the user can perform
updates against this particular table?

If this is a SQL Server table, you can check user permissions in Enterprise
Manager. Double-click the table to open the Table Properties dialog box,
then click the 'Permissions' button up in the top right corner of the dialog
box.
 
Top