473,320 Members | 1,948 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MS Access Creating User

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?
Dec 8 '13 #1
4 1346
zmbd
5,501 Expert Mod 4TB
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).
Dec 8 '13 #2
zmbd
5,501 Expert Mod 4TB
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:
DirectoryWithDBName
SubDirectoryWithDB_Backends
SubDirectoryWith_NormalUserFrontEnd
SubDirectoryWith_SupervisorFrontEnd
SubDirectoryWith_DBAFrontEnd
SubDirectoryWith_DeveloperFrontEnd
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.
Dec 8 '13 #3
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..ty so much for your help :D ..GOD speed
Dec 10 '13 #4
zmbd
5,501 Expert Mod 4TB
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: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
Dec 10 '13 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Ray Lavelle | last post by:
I'm new to VB .NET. In the past when creating an application, if I had an input form I would just call the set and get methods on the object that mapped to my database table in order to store and...
4
by: Ben R. | last post by:
Hello, I've got a text-based .inc file that I'm using for my asp.net site's header. I thought about a user control, but if possible, I'd like to avoid it for simplicity's sake. In the main page,...
1
by: Heather | last post by:
Advice greatly appreciated in in finalising setup for data entry : After splitting mdb should an MDE be stored on each local workstation and the data stored on the server? Should individual user...
2
by: Sarah | last post by:
Hi I have built a database that is currently being used by multiple users. I have not added user-level security to it because I don't understand it very well. I would like to add a audit trail...
4
by: Andy Rigby | last post by:
I'm setting up a small network of 3 WinXp Pro machines and a shared Access database. I need to be able to send faxes from the copy of Access that's running on any of the machines, using VBA. ...
0
by: J'son | last post by:
Guys, I need to build a web intranet application that can automatically create a user account when a new user registers on the site. The user account will be on the web server, member of the...
4
by: RedHair | last post by:
I developed a Win form with VS.NET 2005 + .NET 2.0 in C# There are some application settings are "User" scope and stored in xxx.settings, I can access them via Settings class and changethem with...
1
by: brooksje | last post by:
I am looking for a good way to use password security and user level access control with an Access 2003 database. I got code that does a good job of creating a login procedure using a table of names,...
1
by: qwedster | last post by:
Hola! In the following code snippet, I am creating User Defined Function (T-SQL) programmatically into database from C# Code: BTW, this code originally I wrote for creating StoredProcedure...
4
by: moonrb | last post by:
Hi.......i want to create two account & password for my access database. One account should have the right for operate the db & edit data only in case if wrong data posting but cannot delete the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.