sql server table permissions question

From: Chris (Chris_at_discussions.microsoft.com)
Date: 05/20/05


Date: Fri, 20 May 2005 08:21:03 -0700

Hi,

I have a SQL Server 2000 database. When I create tables in query analyzer or
another tool the new table appears in enterprise manager under the table
table after a refresh.

When I go to the Users tab and click on a user and open up the properties
window and thenthe permissions button I get a list of all the objects in the
database.
However the newly created table(s) do not show up in this list.

How do I make them show up?

Also this is leading to to another question: When accessing these tables in
a Access Data project the only table I can edit is an old table that never
shows up in the list metioned above. My ADP suddenly started to no longer
have tables that were updatable and I think there might be a connection.

any help would be greatly appreciated.

thanks

Chris