How to Give Admin and user access to a data file

  • Thread starter Thread starter navrichard
  • Start date Start date
N

navrichard

Hi All,

I have success fully created a login script for Access 2003, but the
information that i am looking for is that

1. To give admin & user access
-- User = read / write (should not be able to delete or update information on
the d-base)
-- Admin = complete access

I am aware that i can create security settings on tools -> Security!! but i
dont want that to happen!!

The settings need to be got on the form (login information its-self) table
created

2. The user name should be displayed on the form (main) and should be stored
in the table!
 
Hi.
1. To give admin & user access
-- User = read / write (should not be able to delete or update information
on
the d-base)
-- Admin = complete access

I am aware that i can create security settings on tools -> Security!! but
i
dont want that to happen!!
Click to expand...

If a user has write permissions on the file, then he can update and delete
data in the file, unless Access User-Level Security is implemented. If you
have a method that prevents these updates and deletes without User-Level
Security being implemented, then please share it with the rest of us,
because you're the first one who's ever done it, and we'd like to pat you on
the back.

Or perhaps you would like to reconsider User-Level Security. One may
download the Security FAQ, which provides instructions on securing your
database and includes a number of handy code procedures, from the following
Web page:

http://support.microsoft.com/?id=207793

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Hi Thanks for the security Information ,

Now i in another fix with the second part,

I have created the USER ID and password for the table, when a person logs
into the table it should display his/her name in the FORM, and when a data is
saved the displayed name should also get saved,



'69 Camaro said:
Hi.
1. To give admin & user access
-- User = read / write (should not be able to delete or update information
Click to expand...
[quoted text clipped - 5 lines]
i
dont want that to happen!!
Click to expand...

If a user has write permissions on the file, then he can update and delete
data in the file, unless Access User-Level Security is implemented. If you
have a method that prevents these updates and deletes without User-Level
Security being implemented, then please share it with the rest of us,
because you're the first one who's ever done it, and we'd like to pat you on
the back.

Or perhaps you would like to reconsider User-Level Security. One may
download the Security FAQ, which provides instructions on securing your
database and includes a number of handy code procedures, from the following
Web page:

http://support.microsoft.com/?id=207793

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
Hi All,
Click to expand...
[quoted text clipped - 17 lines]
stored
in the table!
Click to expand...
Click to expand...
 
Back
Top