Solved

Disable QUERY design view and new creation IN mde

Posted on 2003-12-03
8
419 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

756 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