Permiss. Read Design Read Data

[Jim]

I am attempting to secure an Access 2000 database and
also hide the design of some objects (hopefully all
queries and tables) from a group I'll call "customers".
The User & Group Permissions window won't allow me to
give permission to read data from these objects without
also forecing me to permit customers to read design of
the objects. If I don't give permission to read data my
forms (and presumably reports) won't open, but if I do
that than my design is exposed. Other than "hiding"
these objects via their properties window, which can be
overridden by a knowledgeable person, is there a way for
me to keep "customers" from seeing the query and table
designs? Do I need to buy Office XP Developer, or will
that even help. (It's about time for me to upgrade
anyway)

Thank you

Jim
(e-mail address removed)

 

[Scott McDaniel]

In order for users to manipulate data, they must be able to read the design
of tables and queries ... they don't need to read the designs of forms or
reports, however. You cannot get around this, but you CAN use RWOP queries
(Run With Owner Permission) to allow access to your data. The Security FAQ
has a section devoted to this:

http://www.google.com/url?sa=U&star...aq.asp&e=1102&mr=D/1!6295_,4!a_D:nr1m_spb2_mo

-
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

"Smash forehead on keyboard to continue ... "