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

Database Newbie Question

P: 78
I am a fairly new Acess User. I am currently building a NonConformance Database for the company I am currently working for. I have been asked to build the database so that there willbe an "user" entry area and an "administrative" side. The "user" side will be shopfloor personnel (anybody) in general able to enter the initial infrormation (entry only). The Admin side will be dispositioning material, reports, queries, etc. I have a switchboard currently set for entry and want to add the connecting side for administrative. However, I do not want the general user to have access to the administrative side. How or what is the best way to control the access to the "administrative" side of the database without requiring all users to login. My idea is to have two workgroups admin and users, but I am not clear how to set this up to not require the users to login. Thanks for your help, and I apologize if this is one of the first things you should know about Access and I don't know it.
Nov 28 '06 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,602
At some point the users must identify themselves.
You can use the Environ() function to return the USERNAME currently in use, but that won't help unless your users log on to the PC in the first place.
If you have the ID of the person using the PC (however you obtain it) then just compare that with a list of Admins to see if access should be allowed to the admin area.
Nov 28 '06 #2

P: 78
Could you please explain this in more detail.

I am attempting to try the Access Security setup as detailed in the Helpful links post from above. http://www.jmwild.com/security02.htm . Like I said I am a TOTAL newbie so I will probably need to ask you many questions concerning this.
Nov 28 '06 #3

NeoPa
Expert Mod 15k+
P: 31,602
I'd rather just answer specific questions.
Nov 28 '06 #4

P: 78
I'd rather just answer specific questions.
I got it on my own thanks for the help.
Nov 29 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.