Solved

Disable QUERY design view and new creation IN mde

Posted on 2003-12-03
8
406 Views
Last Modified: 2013-12-05
How can I disable the the design view and new query creation in mde or mdb, which can block end user modification. Thanks
0
Comment
Question by:snowingnow
8 Comments
 
LVL 4

Expert Comment

by:Thirt
ID: 9866854
Force your users to join an Access workgroup that you created. Then assign the users to groupa. And then assign which groups have premissions that meet your requirements.

The only catch is, make sure you disable the default admin user rights.  If you don't, you will go through all the security effort only to realize those that don't join your workgroup still have complete access.

Or.... if you really want to be evil, remove the full version of Access from thier PC and install the Access runtime client. That will teach em.
0
 
LVL 77

Accepted Solution

by:
peter57r earned 50 total points
ID: 9866869
You would do this with Access security.

This is not a trivial topic.

See here for all the details.
http://support.microsoft.com/default.aspx?scid=kb;en-us;207793

Pete
0
 

Author Comment

by:snowingnow
ID: 9876633
Thanks for the infor, Pete would you please me what does it mean at 10 of question 1? Thanks again
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 77

Expert Comment

by:peter57r
ID: 9895077
Looks like this point has been added in to deal with a bug in the security wizard.
I would say that you should treat this as Step 4A (do it after step 4).
SO at that point login in as your new administrator and create a new database and import everything from the existing db. Then continue from step 5.

Pete
0
 
LVL 9

Expert Comment

by:ornicar
ID: 10075708
----------------------------------------------------------------------------------------
This question has been abandoned and needs to be finalized.
 You can accept an answer, split the points, or get a refund (information at http:/help.jsp#hs5)
  If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

ornicar
Cleanup Volunteer

---------------------------------------------------------------------------------------------
0
 
LVL 32

Expert Comment

by:jadedata
ID: 10258485
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: peter57r {http:#9866869}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jadedata
EE Cleanup Volunteer
0
 
LVL 32

Expert Comment

by:jadedata
ID: 10258490
Thirt:
  This:
    "...if you really want to be evil, remove the full version of Access from thier PC..."

is just plain bad advice unless you KNOW the asker is not going to follow your advice..
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question