Limit user access to tables NEED HELP

C

Cynthia

I have an access database that I have locked the users out, so they can only
view the forms and reports. This way I am limiting what they can input to
what I have allowed on the forms.
This database has tables that link to our SQL. I have found that a user can
start a new database then do a link tables and they get the tables from the
locked database. This gives them open control to all data in my tables. Any
ideas on what I can do to stop this? I cannot limit there access in SQL
because I need them to be able to edit fieds through the access forms.
We would appreciate any help you can give us on this.
 
C

Cynthia

No, I have a project on sql and I link to those tables through access link
table.
 
K

Klatuu

If you are saying you have an Access front end linked to a SQL Server
database, there is nothing you can do to keep the user out of it using
Access. It would require whomever is your database admin to impose security
on the SQL Server database.
 
C

Cynthia

I cannot have security imposed on the SQL because I want them to change info
in the access forms I supply.
I have a database where I have locked it up so they cannot see the tables,
if I could keep there machines from having the link table manager to link
tables function in access then they could not start a new database and link
to mine or the sql tables.
 
K

Klatuu

Not really, Cynthia.
You can set up your database to be able to work with secured SQL Server
data. The users will not know the difference unless they try what you
described. That is, if they open a new copy of Acces and try to link to the
SQL tables, they would not be allowed.

I think you need to talk to your DBA and get some assistance from him/her/
 
J

John Vinson

I have an access database that I have locked the users out, so they can only
view the forms and reports. This way I am limiting what they can input to
what I have allowed on the forms.
This database has tables that link to our SQL. I have found that a user can
start a new database then do a link tables and they get the tables from the
locked database. This gives them open control to all data in my tables. Any
ideas on what I can do to stop this? I cannot limit there access in SQL
because I need them to be able to edit fieds through the access forms.
We would appreciate any help you can give us on this.
Click to expand...

I haven't had to actually do this myself (I may need to soon...!) but
I believe that your solution is to use "RWOP" (Run With Owners'
Permission) queries. You would need BOTH SQL/Server security AND
Access security on your tables; essentially, users would not have any
permission to change or even see the tables themselves. They would
instead have permission only to use the Queries bound to your forms;
those queries would have permission (their owner's permission, that is
to say you as the developer) to update the tables.

John W. Vinson[MVP]
 
Top