Re: Tables and Security

I was mistaken. In access you can create user-level security which will
control what users can do to specific tables. SQL gives column level
control but it appears Access stops at table level control. I would
recommend looking up user-level security in the access help files.
Paul D

"Jon Norlin" <jnorlin@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6EBB72A6-C468-43FA-966C-D7DFBB74CA2F@xxxxxxxxxxxxxxxx
:I have an Access db. So there is no way in Access to set up individual
: users/groups and set up the limitation of what they can and can not see?
I
: am not all the accainted with SQL to know what i am doing there. But if
it
: is not possilbe to do what i want in Access, I will just have to go
another
: way around it. Thianks for your input.
: Jon
:
: "PaulD" wrote:
:
: > I'm not clear on what you are trying to do. First you don't state what
type
: > of database you are using. Acess (AFAIK) only has a top level password,
: > once you are connected with proper password, you can see all tables. SQL
on
: > the other hand, lets you set permisssions to tables and even to specific
: > columns in tables.
: >
: > Paul D
: >
: > "Jon Norlin" <jnorlin@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
: > news:5191DBBC-BF87-4D06-8DD9-3FFE3AFADCF3@xxxxxxxxxxxxxxxx
: > :i have 30 individual tables in my db. the 30 are for each user with in
the
: > : network. what i want to be able to do is run the db from one of my
: > servers,
: > : but only give permission to the specific table to the specific user.
: > Anyone
: > : understand what i am trying to do. i want to set the security, so
that
: > the
: > : user can only view their table. or do i have to use sql to do this.
: > thanks
: > : in advance.
: >
: >
: >


.

Relevant Pages

  • Re: Simple Insert Into...
    ... it is in a control on the form; and is unbound (it's actually a combo ... box that is used as a dropdown list, values taken from a different table; SQL ... I need this value to assign a unique ID to the entire recordset being ... In your form's Sub, you'll wind up with something like the following: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Simple Insert Into...
    ... The form is based on an SQL in the form's Record Source property, ... holds the current text in the control, ... Sometimes the unbound controls do have a value (such as when they are set ... I need this value to assign a unique ID to the entire recordset being ...
    (microsoft.public.access.modulesdaovba)
  • Re: Simple Insert Into...
    ... You can store unbound control data in a variable, ... in the sql. ... Dim strSQL As String ... In your form's Sub, you'll wind up with something like the following: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Simple Insert Into...
    ... The form is based on an SQL in the form's Record Source property, ... control on the form with the resulting value as a bound control. ... Sometimes the unbound controls do have a value (such as when they are set ... Dim strVar as String ...
    (microsoft.public.access.modulesdaovba)
  • Re: passing NUll value in SQL statement
    ... If you place teh cursor over the words that refer to the EPtime control, ... is the WORD "NULL" is placed in the SQL string rather than a NULL ... CurrentDb.Execute ("INSERT INTO TBLANAMPSICHIATRICA ...
    (microsoft.public.access.queries)