Back end Security

[stepone]

Hi folks,

I've built a few simple databases in the past, but never one where security was required. Now someone wants a database where access to certain areas is limited. Everything I read about Access Security here makes it seem complicated, and flaky, so I was wondering about doing something simpler ;

1. Make the Back End password protected so no one can open it

2. Make the front end an MDE. Put certain forms behind a form which prompts for a password. Store the password in a table to allow it to be changed if required.

So this looks like a crude method to me, but it is for a small user base, where the manager needs access to certain info which employees shouldn't see. I suppose if an employee was so minded, and put in some effort, they could get around the simple password-protection, but is it worth setting up proper security for a small project ?

Can anyone offer any advice on how much more secure the database would be if I did it properly ?

Thanks,
StepOne

 

[Boot]

I cant be sure how more secure your database would be but, iam very certain that if you check out the examples on this forum, and bare e few 30mins, you will get what you want and you will never use other methods of securing you database.