Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 5th, 2004, 04:12 PM
Friend of Wrox
 
Join Date: Sep 2003
Location: Madison, Wisconsin, USA.
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne
Default Custom Login Dialog Box For Music Inventory 2001

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
 
Old March 5th, 2004, 08:02 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Oxford, , United Kingdom.
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
 
Old March 6th, 2004, 12:42 AM
Friend of Wrox
 
Join Date: Sep 2003
Location: Madison, Wisconsin, USA.
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne
Default

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.

Quote:
quote:Originally posted by Braxis
 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.
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
 
Old March 7th, 2004, 05:06 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old March 8th, 2004, 04:54 PM
Friend of Wrox
 
Join Date: Sep 2003
Location: Madison, Wisconsin, USA.
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne
Default

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.

Quote:
quote:Originally posted by Steven
 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
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




Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Dialog Box hari.gomatum Javascript 3 October 4th, 2007 02:09 AM
Bypassing login dialog aldwinenriquez ASP.NET 2.0 Professional 1 June 29th, 2006 08:16 AM
insert dialog box in a dialog box BurhanKhan Visual C++ 7 June 1st, 2004 07:53 PM
Custom Dialog Box snakedog Access 1 March 12th, 2004 09:37 PM
Creating A Progress Meter for Music Inventory 2001 Ben Horne Access VBA 0 November 19th, 2003 02:08 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.