By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,321 Members | 1,909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,321 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.