SEO

#1 (**permalink**) 02-28-2008, 05:57 PM

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.

#2 (**permalink**) 02-28-2008, 05:58 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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