MS Access Creating User

[imanoob]

Hi guys.is it possible to create a user with password?.in ms access.and limit each user?

for example

i have two users.
1. alliz
2. maria

i want alliz to add only in my database
while maria can add/edit/delete data.

is it possible guys?

[zmbd]

OS?
ACC-V#?

ACC2003 and earlier - there was a form of user/group security; however, easily bypassed.
You will find a lot of information about using this via a search engine and looking in the Microsoft information sites.

Since ACC2007 - you have to make the user level security yourself....

--------------> HOWEVER:
NOTHING you do in Access will completely secure the database from an above average user intent on making your life hell.
At minimum:
Split the database
Encrypt and password protect the bac-kend
Password protect the VBA project and set the protect from view to true.
Optionally, password protect the front end.
Optionally, encrypt the front end.
Make the MDE/ACCDE version of your front-end

From there there are various methods of tables and tags and what have you.
I use a table that names the groups
then a related table that has the group and permissions
these can be like read/write/etc...
Usually, it is instead group and form. I build the security into the form.
I then have a user table
I then have a related table that has user and group.

You then have to hide the navigation object pane, disable special keys and so forth.

PLEASE KEEP AN OPEN COPY of the front end!
NEVER make the MDE/ACCDE version from this copy, always make a copy first and then make your setting adjustments to this second copy.

If you need true security, then you need to move to one of the more mature RDBMS such as SQL-Server, MySQL, ORACLE, and others. You can still use Access as the front-end to these so no loss of development, just a change in connections and linked tables (if used).

[zmbd]

One more thing I forgot.
I will split the database, and then there are different front ends with differing forms etc...
When I make the database, at the operating level I'll have the following directory structure:
DirectoryWithDB Name
SubDirectoryWit hDB_Backends
SubDirectoryWit h_NormalUserFro ntEnd
SubDirectoryWit h_SupervisorFro ntEnd
SubDirectoryWit h_DBAFrontEnd
SubDirectoryWit h_DeveloperFron tEnd
IT has set me up as the Administrator/Owner over all of these directories; thus, I can assign read/write/view/modify rights via groups and/or individuals. For example, while I'm on vacation one or more of the immediates under me have DBAfrontend directory rights; however, when I come back those rights are removed. The departement manger may or may not have rights to the developer directory but allways has rights to the backend and the other directories.
I'm very carefull to usually not duplicate things between the frontends... all data entry is done thru the normal frontend whereas the supervisore frontend is used to add and change customer information, user logins, or tests parameters. The DBA is the only one with forms that can delete records and soforth).

As you see this requires a great deal of planning and thought. I highly recomend that you diagram the entire scheme first.

[imanoob]

THNX for your reply.. :D
but sad to say im just a beginner, do you have a any links of videos ?.so that i can easily follw some instructions..t y so much for your help :D ..GOD speed

[zmbd]

imanoob:
For this topic, sorry, I do not personally know of any nor are there really any non-comercial solutions/applications.

If; however, you are asking about the basics - there are a few good basic tutorial sites such as:

• MS Access 2010 Tutorials
• Access Basics - By Crystal
• Micrsoft: Office2010 tutorials
• Microsoft: Getting started with Access 2010
• > Database Normalization and Table Structures.

These amongst hundreds of other sites in just about any language you need... I like the first one as it's more like a hands on lab. As you work thru, you create, IMHO people understand things better if they get to "touch" the concepts.

We can help you with a specific question as you develop your database and get stuck.

BOL
-z