NOTE: Scheduled Maintenance for July 5th from 8PM-9PM EDT
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Business Applications
Tag Cloud
audio blue screen boot bsod computer connection crash dell drivers dvd email error excel firefox graphics hard drive hardware hijackthis install internet itunes keyboard laptop malware monitor motherboard network outlook outlook 2003 outlook 2007 problem registry cleaner registry cleaners router screen slow sound trojan ubuntu upgrade usb video virus vista windows windows 7 windows vista windows xp wireless word
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications >
Disabling design mode in Access

Tip: Click Here to Update All Your PC's Outdated Drivers
[ Sponsored Link ]

Closed Thread
 
Thread Tools
DiGiTY's Avatar
Senior Member with 256 posts.
 
Join Date: Oct 2006
21-Nov-2006, 02:12 PM #1
Disabling design mode in Access
I have a Access 2002 database that needs design mode disabled or restricted from certain users, essentially only allowing them to input data... how do I accomplish this???

TIA
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 8,499 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
22-Nov-2006, 05:27 AM #2
Secure the database using the Security Wizard and then set up the user groups for those who can and can't use design functions.
DiGiTY's Avatar
Senior Member with 256 posts.
 
Join Date: Oct 2006
05-Dec-2006, 02:40 PM #3
i've been trying the wizard and it's giving the results I want at all. when I complete the wizard, restart Access and then re-open the file, it just opens... nothing indicating user privileges.

all I wanna do is have a full permissions user and a user who enters data. i kinda got what i wanted without using the wizard by simply adding a user and creating passwords with "User and Groups Accounts..." and defining the security scope with "User and Groups Permissions...". But the problem is it'll ONLY ask for the user/pass on the machine I opened and set the permissions on. I open it from another computer on the network and it just opens as if no permissions were set. the db file is on a shared drive.

any ideas how to get it to use the same security settings on all/any computer it's opened from???
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 8,499 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
06-Dec-2006, 12:03 PM #4
DigiTY, having secured the database the only way that users should be able to open it is by joining the secure workgroup. So if you have secured it and then created the user groups the only thing possible is that the database has lost it's security.
Creating the user groups without securing the database does not work.
I have secured many databases and the only time they have ever lost their securtiy is during a zip/un-zip process and only on very few occasions.
So the way it should work is this.
Secure the database, noting the Secure .MDW file that is created and Desktop Shortcut.
Put that .MDW file on the server in the same folder with the database, if it isn't aleady in that folder.
Create the user Groups.
Give each user a copy of the desktop shortcut (with modified properties if you had to move the .MDW file) The shortcut points to where Access is stored, where the database is stored, where the .MDW file is stored.
The .MDW file holds the permissions of those that can use the database with their security clearance levels.
Create a special Group that is given all Admin rights and then remove them all from the Admin group, so anyone logging in as Admin can't change the database.
__________________
.
.
OBP
I do not give up easily
Closed Thread Bookmark and Share

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.

Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 01:14 PM.
Copyright © 1996 - 2009 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0
Powered by Cermak Technologies, Inc.