f



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

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.
0
alex527 (206)
9/17/2003 6:18:04 PM
comp.databases.ms-sqlserver 14567 articles. 1 followers. janinepelletier (108) is leader. Post Follow

1 Replies
980 Views

Similar Articles

[PageSpeed] 44

alex@totallynerd.com (Alex) wrote in message news:<2ba4b4eb.0309171018.64f186b0@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.
0
alex527 (206)
9/18/2003 1:39:09 PM
Reply: