Access Security

[AfCo]

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!

[NeoPa]

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.

[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...

[ADezii]

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

[MMcCarthy]

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!