Hi Allan,
1: Users should not be even looking at data using the tables. Hide
all of the information behind Queries and Forms.
2: Use the Tools->Startup options to hide the database window
3: Using Tools->Database Utilities->Make MDE to create a compiled
version of your database that has all the code stripped out of it and
all the modify permissions locked out.
I'm not sure what the structure of your database/distribution is but
those three things should lock it down. The biggest of those is to
stop your database showing tables and having users use it like a
spreadsheet. That's the No.1 no-no
Brett
At 11:31 23/10/06, you wrote:
>Hello,
>
>I'm wondering if anyone can give me kind of a "DUMMIES" explaination
>on how to prevent users from being able to change field headings in a
>database without going into users / groups / workgroups, etc.
>However, they do need to insert data and also delete data. I just
>don't want them changing the field headings.
>
>Thank You Very Much,
>
>Allan
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.1.408 / Virus Database: 268.13.9/490 - Release Date: 20/10/06
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.408 / Virus Database: 268.13.9/490 - Release Date: 20/10/06
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/