473,326 Members | 2,813 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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

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
2 1436
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: Sean C. | last post by:
Helpful folks, Most of my previous experience with DB2 was on s390 mainframe systems and the optimizer on this platform always seemed very predictable and consistent. Since moving to a WinNT/UDB...
2
by: John C | last post by:
I am trying to develop a access database version 2002 from scratch and I am a novice programmer and need much direction. I have been researching and studying about relational database design and...
1
by: J | last post by:
Hi, Ive got 3 forms, (a subform within a subform within a form) and when I refresh the outermost form, Access closes and offers to send an error report. The forms worked fine a few weeks ago,...
4
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The...
0
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The...
17
by: DaveG | last post by:
Hi all I am planning on writing a stock and accounts program for the family business, I understand this is likely to take close to 2 years to accomplish. The stock is likely to run into over a...
3
by: Sim Zacks | last post by:
I have a postgresql backend with an access front end and I am trying to redefine the recordset of the form to use an ADO recordset. The problem is that the CursorType always changes to...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
1
by: melissamuse | last post by:
I am using an MS Access 2002 database to track user login information. I have copied Allen Browne's audit log and removed the references to the error handling. So far, on all of my forms (for 7...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.