By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,501 Members | 831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,501 IT Pros & Developers. It's quick & easy.

MS Access 2002 - Forms - Fields - Updatable by Admin ONLY????

P: n/a
Hello:

Thanks for reading this.

I would like to make some on the fields on my Access 2002 Form updatable
only by an admin (or privilidged user). I can't find any references to
this in the docs or books. Can you do this? If so, how?
Thanks,
Richard Hollingsworth

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Richard,

Access has built in security that will make this possible. Microsoft put
together a big, dense document on the topic. It takes a few reads, but it is
fully usable. You can get it from them, or from my website, in the
Developers' section. I'm about to update my website, and when I do that,
I'll include a document I just wrote that details the process of securing a
database a bit more than their document.

It's a big topic, so be patient with the learning process.

Jeremy

--
Jeremy Wallace
AlphaBet City Dataworks
http://www.ABCDataworks.com
"Richard Holliingsworth" <wi*********************@boeing.com> wrote in
message news:Hs********@news.boeing.com...
Hello:

Thanks for reading this.

I would like to make some on the fields on my Access 2002 Form updatable
only by an admin (or privilidged user). I can't find any references to
this in the docs or books. Can you do this? If so, how?
Thanks,
Richard Hollingsworth

Nov 12 '05 #2

P: n/a
Access security does not extend to the field level as you might like, if you
mean there are other fields on the form that other users can update. It'll
be better to create a separate form for Admin users to update the fields,
and to place those fields in a separate (but could be linked by foreign key)
table. That way you can do it all with Access' security; but remember Access
security can be broken by anyone with $150 or so to spend -- less for
outdated versions of Access.

Larry Linson
Microsoft Access MVP

"Richard Holliingsworth" <wi*********************@boeing.com> wrote in
message news:Hs********@news.boeing.com...
Hello:

Thanks for reading this.

I would like to make some on the fields on my Access 2002 Form updatable
only by an admin (or privilidged user). I can't find any references to
this in the docs or books. Can you do this? If so, how?
Thanks,
Richard Hollingsworth

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.