473,788 Members | 2,856 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

user permissions and shift key on startup

If a user starts up access while holding down the shift key, the
database will open without going to the startup form. This allows the
user to actually open a table and change data that he would not
normally be able to change. His user name would not allow him to open
a form that give him access to all fields in a record. Normally he is
restricted to a form that only shows fields that he is allowed to
change.

Is there a way to keep the user from starting up an access database
while holding down the shift key?
thanks
Nov 13 '05 #1
1 3232
Bob Weisenburger wrote:
If a user starts up access while holding down the shift key, the
database will open without going to the startup form. This allows the
user to actually open a table and change data that he would not
normally be able to change. His user name would not allow him to open
a form that give him access to all fields in a record. Normally he is
restricted to a form that only shows fields that he is allowed to
change.
He shouldn't have permission on the table to begin with. Instead create a
RWOP (run with owner permissions) query and base your form on that. Give
them the necessary permission on the query, and deny all permissions on the
tables.

Is there a way to keep the user from starting up an access database
while holding down the shift key?


To disable the shiftkey bypass see
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm
--
Joan Wild
Microsoft Access MVP
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2717
by: strict9 | last post by:
I've been searching for hours for a CMS which has a lot of options for user permissions. It has to be free and while mySQL is fine, it can't require root permission to install. Specifically, I want to be able to create news annoucements and links to files, images, etc that only users of a certain group can access. Basically, this is going to be the internal section of my company's website where clients will login to get news pertaining...
1
1485
by: Jon Ley | last post by:
I posted a message regarding a problem I'm having with SQL server 7 not taking any notice of the permissions that I'm setting up on my database tables (see thread "SQL Server 7 ignores user permissions" started on 10/10/2003). I did get one response to this original message, but unfortunately this did not resolve my problem. Can anyone else shed any light on this issue for me please? Thanks, Jon Ley.
2
1676
by: ruca | last post by:
hi, How can I setup the user permissions over some pages of my web application? I want to deny that some users access some of my web pages. How can I do this in code? At this moment I have a session variable that have False or True value. I get this value from my DB. Then in my Page_Load event I have this:
1
2216
by: Amol Shambharker | last post by:
Hello Everyone, I have been working on setting up a windows 2003 machine with IIS 6.0.The web server has the web directory on a UNC share on a windows 2003 server.I want to migrate websites from a windows 2000 machine to this one using the migration tool.The problem with doing this is the migration tool does not migrate the FPSE user permissions across.Part of the problem I am sure is that the windows 2000 machine has the FPSE user permissions...
1
5698
by: James | last post by:
What folders should the ASPNET user have permissions for, & what should they be? I keep getting 'Access Denied' or 'Server Access Denied' errors. I have given the ASPNET user Read & Execute Permissions to my wwwroot folder, & the application lies within a 'NET' sub folder. However, I get an "Access Denied to 'C:\Inetpub'". Is there a definitive list of the folders I need to give this user
1
2009
by: x | last post by:
hi i have made a small database for pilots to log their flying time. i want to set either some user permissions or startup options so that the user might not see the database window nor he/she should be allowed to access it anyway. i also want that whenever being administrator i want to make any modifications in the design of the db i should be able to access all the features from the same file. i have tried using the startup option in...
0
1375
by: tony | last post by:
hi. the web server company block all the write permission for the IUSER . they told me to change the settings in my side, to upload and write files throught FTP user permissions. I add the < identity impersonate="true" userName="domain\user" password="password" /> with the right values, but now im getting :
0
1705
by: anil | last post by:
Hi all I am working on the database bit like of auditing. The database is simple only thing is the permissions to various users.In the database the audit report(memo field) is issued to each authorised person(AP) of department and he has to comment(memo) on that and perform action(memo). It is required that when user or AP open the form he is only able to see his
1
1181
by: Jeff9458526 | last post by:
Hi I am a newbie to database design and I have a database that I created and I set up User permissions and passwords to allow different group different permissions with the database. It works great with my computer, but when I put the database on another computer, it does not ask for any logon. I need to be able to upload the database to an FTP site, many users download it and make queries and perform data entry depending on their security...
0
1634
by: TintuMJ | last post by:
How can we generate a Script with all user permissions of all users in a particular database in SQL Server 2005. It should be in such a way that if we run this script later, all these permissions are assigned to the users.
0
9656
marktang
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...
0
9498
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10373
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10177
jinu1996
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...
0
9969
tracyyun
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...
0
8995
agi2029
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...
0
6750
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();...
0
5403
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...
1
4074
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 we have to send another system

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.