Hi all,

I would like to create a custom login dialog box for my Music Inventory 2001 app that basically works the same way as the built-in User-Level Security login but I want more control over who can access the application. I'm not a fan of using User-Level security at all.

Why?


[*]If I haven't specified a password or permissions for a user, that person has unrestricted access to the data.


My dad is listed as the default user on my home computer and I did not specify permissions for him so that means he could potentially mess with the data.


Here's what I need:

I need a form with these fields(User, Password) that serves as the login point when users first open Music Inventory 2001. I should also mention that I will need to create a table that houses information about all registered users.

If the user enters invalid data, the switchboard CANNOT open. A message needs to appear stating that they are denied access. I have a splash screen form that appears on application startup and when that form closes, the switchboard opens. I can get the VBA code changed so that the Login form opens.

Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself

__________________
Ben Horne
-------------------------
I don\'t want to sound like I haven\'t made any mistakes. I\'m confident I have.

Most likely using FireFox and concocting my next Macromedia Flash project
Snibworks Forums Moderator

Welcome to the New Age

Ben

It sounds like you've forgotten to remove all permissions for the default user and admin accounts from your database. if you don't do this and the database is opened using the default system.mdw, the user will have complete control over your database.

Basically, Access user-level security works perfectly, so long as it's set up correctly and will protect you against anything up to someone physically stealing a copy of your database and opening it up in a text editor.

Have a trawl through Beth's recent posts - there;s a link there to a Microsoft white paper that details the steps you need to go through to secure an Access database.


Brian Skelton
Braxis Computer Services Ltd.

Brian,

Thanks for the reply. Actually, what I've done is this: I've deleted the account for Don Horne (my dad) so now, he does not have a way to access the database.

Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself

This is Access you're dealing with right? not Windows?
In this case it doesn't matter what permissions the "Don Horne" account has, or if it is deleted. As long as the "Admin" account has free reign, then anyone can do anything.
"Admin" is the default account.
Make sure the "Admin" account has no permissions.
The "Don Horne" account means nothing

I am a loud man with a very large hat. This means I am in charge

Wow!

This is interesting. I'll have to work on the database permissions a bit more when I get around to it. Also, I made a big mistake in one of my earlier posts on this topic saying that I have User-Level Security for Music Inventory 2001. I actually have password-protection enabled for that database. The User-Level Security I referred to is enabled for my Flash MX 2004 MovieTracker database.

Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself