Access Projects/SQL

[Guest]

I have a database that is on a SQL Server. I have an Access Projects set up
for this database. I need to add a new table to my database and am not sure
what to do. I have added it to the Access Project but from there I am not
sure how to get my new table into the database so that it is protected. Can
anyone help me with this?

 

[Guest]

In SQL Server Enterprise manager, go to the Users icon of your database,
double click on the user(s) having access through Access ans select the
"Permissions" button. Iif you have several users, then create a role, and
assign users and permissions to that role.
Joe

 

[Norman Yuan]

Access ADP is merely a front end app/tool to SQL Server. If you HAVE added a
table via ADP, the table then has been added into the database on SQL
Server. ADP itself does not have tables. The table, once added, will be
protected according to the SQL Server/Database's security settings (logins,
users, roles, permissions...)