Permissions Issue when linking to MS SQL 2000 DB from MS Access XP

[Alex]

Hello,

We have a database in MS SQL 2000 and I'm trying to link to it from MS
Access XP. I've created a user with full access to one specific table
in the MS SQL database, but Access won't write to it.

I can open this table in MS Query Analyzer and log-in as the user, and
I can do update, delete, and select queries just fine... but when I
link to the table from MS Access using the same MS SQL
username/password, I can only read the data... no write or delete.

Since I can update data fine in MS Query Analyzer, I assume
permissions are setup properly. Anyone know why I can not edit the
linked data from MS Access?

Thanks,

Alex.

[Alex]

al**@totallynerd.com (Alex) wrote in message news:<2b**************************@posting.google. com>...

Hello,

We have a database in MS SQL 2000 and I'm trying to link to it from MS
Access XP. I've created a user with full access to one specific table
in the MS SQL database, but Access won't write to it.

I can open this table in MS Query Analyzer and log-in as the user, and
I can do update, delete, and select queries just fine... but when I
link to the table from MS Access using the same MS SQL
username/password, I can only read the data... no write or delete.

Since I can update data fine in MS Query Analyzer, I assume
permissions are setup properly. Anyone know why I can not edit the
linked data from MS Access?

Thanks,

Alex.

I found the solution... and it's one I should've known as I've ran
into this in the past.

I didn't set any identity/Primary Key on the tables I was linking to
in MS SQL. Did this and I was set to go.

Alex.