How do I grant users full access to a table?
From: Don (firstname.lastname@example.org)
From: "Don" <email@example.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?