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

Access Security

P: 1
Like most on this forum I'am not a programmer. I'm not exactly new to Access, but it has been several years since I have created a database.

I have created a database in Access 2003. I will have 5 total user's (including myself) so far. The database will be ran on 5 different workstations. Now, I have created this on my workstation (not the server) and I'm trying to figure out what type of security I should use. I would like all users to have specific permissions, however I have heard that Access's built in Security Wizard does not work well. I have tried using it before and it literally kicked me (as Admin) out of my own database! Does anyone have any ideas on what I could use?! Preferrably something user friendly that doesn't require me to write any code. :) Thanks so much!
Nov 10 '06 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,494
I don't think there is any possibility of using any other form of security in an Acess database.
The good news is that it shouldn't require coding.
Explore the 'Security' item on the Tools menu.
Nov 11 '06 #2

PEB
Expert 100+
P: 1,418
PEB
Or define your own security for those users without using the built -in securities..

In those case you have to do some coding and defend the Access to the main database window and some buil-in functions...

Also see the question about the Shift key...

It was discussed here... And your security can be very performing...
Nov 11 '06 #3

ADezii
Expert 5K+
P: 8,638
Like most on this forum I'am not a programmer. I'm not exactly new to Access, but it has been several years since I have created a database.

I have created a database in Access 2003. I will have 5 total user's (including myself) so far. The database will be ran on 5 different workstations. Now, I have created this on my workstation (not the server) and I'm trying to figure out what type of security I should use. I would like all users to have specific permissions, however I have heard that Access's built in Security Wizard does not work well. I have tried using it before and it literally kicked me (as Admin) out of my own database! Does anyone have any ideas on what I could use?! Preferrably something user friendly that doesn't require me to write any code. :) Thanks so much!
One helpful hint may be to assign specific permissions to Objects within the
Database to pre determined Groups and not individual Users. It's a lot easier
to assign permissions to a Groups then add Users to them then it is to assign
individual permissions. Also, make sure to disable the Shift-By Pass key
combination if security is a real issue. If you need the code, I'll be more than happy to supply it to you. You may also want to consider assigning Administrative privileges to a User than the Defalut admin and then removing the admin User from the Admin Group, etc.

Hope this helps
Nov 11 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
Check this site out. It covers all aspects of Access security thououghly.

http://www.jmwild.com/Accesssecurity.htm


Like most on this forum I'am not a programmer. I'm not exactly new to Access, but it has been several years since I have created a database.

I have created a database in Access 2003. I will have 5 total user's (including myself) so far. The database will be ran on 5 different workstations. Now, I have created this on my workstation (not the server) and I'm trying to figure out what type of security I should use. I would like all users to have specific permissions, however I have heard that Access's built in Security Wizard does not work well. I have tried using it before and it literally kicked me (as Admin) out of my own database! Does anyone have any ideas on what I could use?! Preferrably something user friendly that doesn't require me to write any code. :) Thanks so much!
Nov 12 '06 #5

Post your reply

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