Hi
I want to protect an MS Access 2007 database I have created so that users cannot use anything other than the forms I have put in place. I have been able to create a login page which requires they use a password to get to the sub forms, so from that point of view I am happy.
What I have noticed however, is that I can use the built in options to hide the navigation pane and menus, but actually they're quite easy to find again if you simply right click on the menu bar. This is a typical Microsoft stupid problem. I do not want to password protect the whole database because then the users need that password just to get into the database and once in whatever controls I can access, so can savvy users.
Does anyone know how to protect the database in such a way that allows users to have full access to update forms, run reports, etc, but doesn't allow them to mess with the fabric of the database itself?
Any help greatly appreciated - thanks!!
3 2966
Hello...
In design view in the database, go to tools and then startup.
Uncheck all the windows, such as; Display db window, display status bar, allow full menus, ect.....
uncheck all of these and they will not be able to manipulate the data.
NeoPa 32,568
Recognized Expert Moderator MVP
This is true, but be VERY wary of locking YOURSELF out too.
A backdoor is normally coded in before removing all checks as suggested here.
Holding down shift while opening up the database will bring the database window up.
You can disable the right click by using this code (has to be used on every form)
Forms!<form name>.ShortcutM enu = False
Also go into VBA click on tools, properties and set a password for your vba code. They won't be able to import, export or view the code without first going into vba design mode which will ask for the password.
There is a way to disable the shift key, however you will never be able to open it again in design view. I high recommend against this, but you really need it the code is: - Sub DisableShiftKey()
-
-
Dim db As DAO.Database
-
Dim prp As DAO.Property
-
-
Set db = CurrentDb
-
Set prp = db.CreateProperty("AllowBypassKey", dbBoolean, False, True)
-
db.Properties.Append prp
-
-
db.Properties.Refresh
-
-
Set prp = Nothing
-
Set db = Nothing
-
-
End Sub
If you run this function, next time you open it you will not be able to get to the database window by holding down the shift key. This is permanant, once you run this function consider your database totally locked for good.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: siliconmike |
last post by:
Is there a way to protect data files from access by root ?
I have a data-centered website and would like to protect data piracy
from any foot-loose hosting company employee.
Any ideas?
Thanks
Mike
|
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
to protects it's structure from my appliction users. Only my
application can access the database.
Thanks
|
by: Frank Millman |
last post by:
Hi all
I am writing a multi-user accounting/business system. Data is stored in
a database (PostgreSQL on Linux, SQL Server on Windows). I have written
a Python program to run on the client, which uses wxPython as a gui,
and connects to the database via TCP/IP.
The client program contains all the authentication and business logic.
It has dawned on me that anyone can bypass this by modifying the
program. As it is written in Python, with...
|
by: David LACASSAGNE |
last post by:
Is it possible to set a password to protect the code of an Access VBA
project by automation (I already know how to to it manually)?
David.
|
by: Giganews |
last post by:
I have an Access 97 database in which I am running an Excel macro through
automation. The macro in Excel is as follows:
Worksheets("Sheet1").Protect Password:="****", DrawingObjects:=True,
Contents:=True, Scenarios:=True
When I call this macro from the database all works fine except when I
recorded the macro I deselected the "Select locked cells" option under the
"Allow all users of this worksheet to:" section but yet when I access the...
| |
by: teejayem |
last post by:
Hi,
I am new to programming with databases and was wanting some help.
Is there any way to password protect an access database and access
sent sql commands to it via vb.net code?
Any help would be much appreciated.
Thanks in advanced.
|
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 data and I can not
begin with selling process with protection like that.
What I should do, is there some example of encryption data within db
|
by: Idang |
last post by:
Hi...would please help me, how to protect my database, i donot want
anyboy else changing such as queries, forms, reports i made. I have
already set the security level but i am still doubt.
Thanks much yr help.
|
by: mulamootil |
last post by:
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...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |