Hi - I have created multiple tables and forms for a database. We are entering data into the tables using forms which in turn are linked to items on a switchboard. I would like multiple users in different departments to have access and enter data using the forms. The items on the switchboards are created for different departments and I would like to password protect each of these items so that it is accessible by respective depts. I am not sure if it is poosible to password protect each item on a switchboard. Could someone please help. I am new to MS Access 2007 or any database management programs.
Also, how can we protect a record in the table from getting deleted by somebody.
Thanks in advance.
10 13395 MMcCarthy 14,534
Recognized Expert Moderator MVP
I am not aware of any way of doing this with the built in switchboard but then I never use it as I build all my own menus which allows me to set any extras into the code behind the buttons as I build.
Hi, and Welcome to Bytes!
On your concerns about protecting individual records from deletion, Access is not designed to provide record-level access rights. With SQL Server and other client-server back-end databases there are many choices for user access rights, but not with Access I'm sorry to say. You would have to implement user-level security measures yourself - there is no automatic way to do so, and in Access 2007 the limited security features that had been available in earlier versions of Access were discontinued.
Similarly, to use bespoke switchboards you will need to have custom user security available, programmed to offer different users different views of the forms etc.
One approach is to identify individual users by using custom functions to retrieve their network log-in IDs or user names, and on opening the database use the network ID of the current user to determine permissions and other settings from data you store in a custom user table which you will need to maintain and administer.
There is no automated way I know of to do all this, as Access simply does not have built-in features for handling such bespoke security.
-Stewart
ADezii 8,834
Recognized Expert Expert
You can 'sort of' Password Protect every Switchboard Option. Simply have the Switchboard Items call Public Functions within which Password functionality can be incorporated. If the User passes the test, the code will fall through, if not you can simply Exit the Function.
@msquared
Okay thank you. Let me try that. Do you have to write a code once you have created your own switchboard.
nico5038 3,080
Recognized Expert Specialist
I use my own menu's too and have a login table with username and the authorization level. This level is the trigger to show the main menu for that type of user.
Creating your own menu is really easy and gives full flexibility.
An alternative might be to create multiple front ends from one "main" front-end database that hold all the functions for that specific department. That way they never can access "wrong" forms as they aren't there...
Nic;o)
MMcCarthy 14,534
Recognized Expert Moderator MVP
Or the other way I like to do it is set user level access and enable/disable menu buttons based on the users access level. Then although the user can see all options on the menu they can ony select those that are enabled for them.
I dont think you can password protect your forms without using some bit of Visual Basic for Applications (VBA) coding.
To prevent users deleting posts the forms (atleast it did in 2003) have an option "Allow deletions" which can be yes or no. This would of course apply to all users of the form. Again, its possible to provide password/user specific access to such a delete function but it requires VBA coding. Not terribly complicated coding, but coding nonetheless.
@Stewart Ross Inverness
Thanks Stewart. I created my own menu and got a VBA code from the net to password protect each button and it worked. Thanks for your help.
Stan
@TheSmileyOne
Thank you so much . I used VBA code and it worked.
Stan :)
@ADezii
Thank you very much. Yes I used a code by creating my own menu instead of switchboard and it worked.
Stan
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Parham |
last post by:
Hello,
How to protect structures(Tables,SP,Views and Functions) of a SQL
Server Database?(Password protect a database file)
I have a SQL database that will distribute with my application, I want...
|
by: tom |
last post by:
I am new to SQL administration.
>From a list of IDs that are the primary key in one table (i.e. Customer
Table), I want to make changes in tables that use those IDs as a
foreign key.
...
|
by: Paul T. Rong |
last post by:
Dear all,
Here is my problem:
There is a table "products" in my access database, since some of the
products are out of date and stopped manufacture, I would like to delete
those PRODUCTS from...
|
by: SueB |
last post by:
Hi.
I have been working on an Access Db for awhile and am very close to
being ready to hand it over to the person who requested it. There will
be one user and the db will reside on a desktop...
|
by: BrianDP |
last post by:
I have a database with a split front end/back end. There is a key
table in the back end called Catalog, and it is sort of a central key
table for all sorts of things. It's a list of all the jobs...
| |
by: Mike |
last post by:
Hi,
If protect MS Access with password it doesn't mean to much. On
internet, we can find plenty tools for opening forgotten passwords
etc.
I have a small c# aplication wit large amount of...
|
by: shriil |
last post by:
Hi
I have this database that calculates and stores the incentive amount
earned by employees of a particular department. Each record is
entered
by entering the Date, Shift (morn, eve, or night)...
|
by: cefrancke |
last post by:
I have a few tables with sensitive user information (passwords, etc.)
and I would like to prevent someone from opening a blank database and
importing those tables.
Is there a way to "hide" or...
|
by: Steve |
last post by:
I have zero experience with ODBC. If I have an Access frontend connected to
a SQL Database using ODBC, are the tables connected like a frontend/backend
Access database where the the tables you see...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |