How do I grant users full access to a table?

From: Don (unknown@oblivion.com)
Date: 03/21/03


From: "Don" <unknown@oblivion.com>
Date: Fri, 21 Mar 2003 22:12:38 GMT


I'm new to SQL Server 7 and I've just imported a bunch of tables from an
Access 2000 MDB into an SQL Server database. I have an Access 2000 front
end connected to this SQL Server database, and when I open a table in
Access, I can't add new records (i.e. I don't get the "add new record" row
at the bottom of the table).

How to I grant everyone access to this new table so they can add, edit,
delete, etc. records?

- Don