Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 12th, 2003, 10:03 AM
Authorized User
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Default Tables & Queries question

Does anyone know of a way to restrict folks from having access to a DB's tables and queries? I have installed my own version of User Level Security and compiled the DB into an *.mde file but that does not stop someone from creating a blank DB and importing my tables and queries. It appears that the *.mde file protects everything that has some sort of code attached to it. If this is the answer I am not aware of any way to attach code to a table or query.

Any answers or ideas here would be greatly appreciated.

Kenny Alligood
Kenny Alligood
Old July 13th, 2003, 08:15 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts

Have you wiped off every privelidge from the inbuild "Admin" account? If not - do that immediately.

Another way you can do it - and this is a bit of a massive task - not a quick fix at all - is to use RWOP - there's a few details about it in the Access Security FAQ

and more I think there's more info in the Access Developer's Handbook (Volume II) ( I don't have the book on me at the minute).

But if you don't let the "admin" do anything at all - and I mean - not even open the database - then you should probably be ok


There are 10 kinds of people in the world - those who understand binary - and those with friends
Old July 14th, 2003, 11:14 AM
Authorized User
Join Date: Jun 2003
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts

One quick note if you do that Kenny: make sure you make a backup incase the privileges are not set correctly and you cannot get back in.

That probably goes without saying but I wanted to make sure we avoid seeing another post asking how you get into a locked DB!

-Shay Shepston

Similar Threads
Thread Thread Starter Forum Replies Last Post
Parameter queries and make tables deanm5 Access VBA 1 April 13th, 2007 11:32 AM
creating temporary tables instead of queries clwk Access VBA 4 March 12th, 2007 02:50 PM
HELP! Tables and queries in school project joseph.novak SQL Language 0 October 29th, 2005 01:13 PM
Making DDL queries to linked tables jkuusik Access VBA 1 May 2nd, 2005 09:50 AM
Blank fields - queries with many tables dvarrin Crystal Reports 0 February 1st, 2005 05:43 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.