Access using odbc to connect with SQL server

My workstation is XP prof sp2 w/ office XP under a domain policy.
i act as "administrator" using Access XP to connect with SQL server.
i can view and add records to the SQL server.
at the same workstation, i act as "normal user with normal rights" using
Access XP to connect with SQL server.
i can view BUT cannot add records.
The odbc is the same one. i also use the same login account with SQL
server.
How come i cannot add records? Thanks a lot.
Tony
The issue is not with the client but with the SQL Server whereby your
user-mode connection doesn't have permission to update the server.
You'll need to update the SQL Server to add these permissions to the
databases you want to use. Do a query under 'GRANT' privileges topics on
Books On Line for more details for the queries you want.
| From: "Tony WONG" <x34@.hknet.com>
| Subject: Access using odbc to connect with SQL server
| Date: Mon, 1 Aug 2005 17:21:42 +0800
| Lines: 19
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#GsS1pnlFHA.572@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: 202.64.158.2
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2524
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| My workstation is XP prof sp2 w/ office XP under a domain policy.
|
| i act as "administrator" using Access XP to connect with SQL server.
|
| i can view and add records to the SQL server.
|
| at the same workstation, i act as "normal user with normal rights" using
| Access XP to connect with SQL server.
|
| i can view BUT cannot add records.
|
| The odbc is the same one. i also use the same login account with SQL
| server.
|
| How come i cannot add records? Thanks a lot.
|
| Tony
|
|
|

Access using odbc to connect with SQL server

My workstation is XP prof sp2 w/ office XP under a domain policy.
i act as "administrator" using Access XP to connect with SQL server.
i can view and add records to the SQL server.
at the same workstation, i act as "normal user with normal rights" using
Access XP to connect with SQL server.
i can view BUT cannot add records.
The odbc is the same one. i also use the same login account with SQL
server.
How come i cannot add records? Thanks a lot.
TonyThe issue is not with the client but with the SQL Server whereby your
user-mode connection doesn't have permission to update the server.
You'll need to update the SQL Server to add these permissions to the
databases you want to use. Do a query under 'GRANT' privileges topics on
Books On Line for more details for the queries you want.
| From: "Tony WONG" <x34@.hknet.com>
| Subject: Access using odbc to connect with SQL server
| Date: Mon, 1 Aug 2005 17:21:42 +0800
| Lines: 19
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#GsS1pnlFHA.572@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: 202.64.158.2
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2524
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| My workstation is XP prof sp2 w/ office XP under a domain policy.
|
| i act as "administrator" using Access XP to connect with SQL server.
|
| i can view and add records to the SQL server.
|
| at the same workstation, i act as "normal user with normal rights" using
| Access XP to connect with SQL server.
|
| i can view BUT cannot add records.
|
| The odbc is the same one. i also use the same login account with SQL
| server.
|
| How come i cannot add records? Thanks a lot.
|
| Tony
|
|
|