I'm using Access 2000 on Win XP / SP1.
I think I'm not able enough to understand your saying. I'll read the
faq you suggest me.
In the meantime you know some library or else for use encrypt/decrypt
functions in table selected data write/read?
Tnx
Nico
MGFoster <me@privacy.com> wrote in message news:<sutWc.31636$9Y6.1169@newsread1.news.pas.eart hlink.net>...[color=blue]
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> What database engine are you using? Encrypting an Access/JET db
> encrypts all the tables in the db. You might be able to link to an
> encrypted db and to an unencrypted db. Once the tables are encrypted,
> only users w/ permissions can read (translate to clear text) the data.
>
> Users can be assigned access to separate tables, queries, forms,
> reports. You designate who gets what in the Tools > Security > User and
> Group Permissions menu item.
>
> It would seem that you'd grant permission to the users you want to
> "access in clear" and deny permission (not grant access) to users who
> "have no access to clear format."
>
> --
> MGFoster:::mgf00 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBQSpkBIechKqOuFEgEQLDigCg9tG8LTJ3wXhTEPUNqxZ5ML//kpwAn0Vw
> cMZCPCXJK+07Z6Syqr/6zFeu
> =CP/o
> -----END PGP SIGNATURE-----
>
> Nico wrote:
>[color=green]
> > MGFoster <me@privacy.com> wrote in message news:<wMRVc.9288$3O3.3121@newsread2.news.pas.earth link.net>...
> >[color=darkred]
> >>Nico wrote:
> >>
> >>
> >>>My database have 20 tables and many users. I wish to store encrypted
> >>>data in 3 tables and have only 3 users have access to them, walking
> >>>into tables or using forms.
> >>>
> >>>Can someone point me a direct help or something to read?
> >>>
> >>>Tnx
> >>>Nico
> >>
> >>Read the security faq:
> >>
> >>
http://support.microsoft.com/default...93&Product=acc[/color]
> >
> >
> > Tnx, I know it but doesnt solve. My needs are different:
> >
> > - data always encrypted in some tables;
> > - some users may access in clear from forms, some others have no
> > access to clear format or access to encoded/encrypted format
> >
> > Nico[/color][/color]
Different users, different access using encrypted data 
