Table record editing permissions

From: ChrisB (anonymous_at_discussions.microsoft.com)
Date: 12/02/03 

Date: Tue, 2 Dec 2003 06:33:40 -0800

By the bye... anytime you change SQL table schema you must
refresh your table linkes in MSAccess. In other words,
delete link then re-create.

ChrisB
MCDBA MCSE
www.MyDBA2000.com

>-----Original Message-----
>I'm a newbie to SQL Server 2000 and I've got a problem I
>can't resolve. I recently downloaded the trial version of
>the server. I've learned how to create a database with
its
>associated data table and fields. I've also learned how
to
>create and connect my database to an Access project.
>
>But here's my problem: I can't edit my data table records
>via my Access project. I've already been through the
>process of setting permissions to insert, update, etc, my
>data table. But when I try to set permissions to select
>and update columns, the list of columns disappear when
>selecting the button, "list only columns with permissions
>for this user". The user is Public. If I select the
>button, "list all columns", I can check the boxes to
>select and update the columns but still I can't edit my
>records. Can someone tell me what I'm doing wrong in
>trying to set permissions to allow anyone to edit my data
>table records?
>
>Thanks in advance - Ron
>
>.
>

Loading