alex@totallynerd.com (Alex) wrote in message news:<2ba4b4eb.0309171018.64f186b0@posting.google. com>...[color=blue]
> 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.[/color]
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.
