How can I set up that user can't read the database?

T

Techneut72

I'm building a database that I'm going to use for storing information that
coming from backupservers all over the world. For so far it works perfect,
but.....

The problem is when I put a lot data in my form, I can use my
navigationbuttons to scroll and see every data in the database. That is just
NOT I want to see. I want this option blocked or what ever.

This, because when de I've finished the tool, other people going working
with it. And so they can change some data when they used the
navigationbuttons OR simple used the mousewheel to scroll the data on the
screen.

Is there a (simple) manner to avoid this?????????
 
S

Stefan Hoffmann

hi,
The problem is when I put a lot data in my form, I can use my
navigationbuttons to scroll and see every data in the database. That is just
NOT I want to see. I want this option blocked or what ever.
Click to expand...
Create a query to filter the data you want to see and edit. Use it as
record source for your form.

Or if it is sufficient to enter data only, set the property DataEntry to
True.

mfG
--> stefan <--
 
K

kingston via AccessMonster.com

You can set the form's DataEntry property to Yes so that the form can only be
used for adding new records. However, the user will still be able to see the
table and get to the data that way. One way to avoid this is to create a
temporary table in the front end where the user's data is stored, and when
the data is to be saved (via a procedure on the front end), establish a
temporary link to the actual table via VB. Another way that might work is to
tie the form to a temporary table in the back end via a linked table. Then
you can run a script to append data from the temporary table to the real
dataset. This way, there is no possibility of the user ever getting to the
real data through the front end and you can validate the data before storage.
 
B

Bob Hairgrove

I'm building a database that I'm going to use for storing information that
coming from backupservers all over the world. For so far it works perfect,
but.....

The problem is when I put a lot data in my form, I can use my
navigationbuttons to scroll and see every data in the database. That is just
NOT I want to see. I want this option blocked or what ever.

This, because when de I've finished the tool, other people going working
with it. And so they can change some data when they used the
navigationbuttons OR simple used the mousewheel to scroll the data on the
screen.

Is there a (simple) manner to avoid this?????????
Click to expand...

To do this right, you will need to set up user and group permissions
for the data objects as appropriate. Also, you will need to store a
code of some kind in your table telling you which users get to see
which set of data. Then you will need to base the form on a select
query which filters the records according to which user is currently
logged in. Using VBA, you can retrieve the user name with the
UserName() function of the currently open workspace (or of another
workspace if you have multiple instances).

Another option would be to split off some columns which shouldn't be
seen by all users into a separate table and create a 1-to-1
relationship between the primary key columns. Removing permissions for
certain groups on the "sensitive" table is pretty easy.

IOW, how simple do you want it? Setting up permissions and security in
Access is not trivial, but it is fairly straightforward. Most of all,
you need to understand the security model so as not to make any
mistakes.

[Does anyone have a link to Mary Chipman's white paper on Access
security???]
 
Top