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.
[*]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.
Madison Area Technical College student
Go there. I have a lot of awesome photos that I rendered myself