Back/Front End Security

[Theresa]

I have the back end tables secured with no permissions for
any ID's except the administrator ID.

On the front end I give permission to the tables but it
will not let me open the tables to be used in the front
end application. When I look it says the user ID has
permission to read, update etc.

The database already exisisted and some of the forms are
already based on the tables.

Thanks,
Theresa

 

[Joan Wild]

I have the back end tables secured with no permissions for
any ID's except the administrator ID.

On the front end I give permission to the tables but it
will not let me open the tables to be used in the front
end application. When I look it says the user ID has
permission to read, update etc.

They have permission to read, update on the links (not the tables in the
backend).

The database already exisisted and some of the forms are
already based on the tables.

You should create queries for the recordsource of your forms. Set the Run
Permissions property to Owners. Then give the users appropriate permission
on these queries. They won't need any permissions on the tables or the
links.

 

[Theresa]

Joan,

Thanks. All of the documentation found out on the
web/microsoft says that you can set permissions at both
levels front and back.

As I've read from a lot of your post, I have good results
from your answers and there are a lot of incorrect posts
out there. I'll give it try.

Thanks,
Theresa