Can you alter the default login form?

[Me!User]

Is it possible to modify the appearance of the default login form used by Access Security?

I've revealed all Hidden and System objects but there is no evidence of the login form. Is it accessible or is beyond a programmer's reach?

 

[o1110010]

Is it possible to modify the appearance of the default login form used by Access Security?

Yup! Change startup based on user

Here are two others that may be of use but I am pretty sure that first link will do it.

http://www.access-programmers.co.uk/forums/showthread.php?t=63677
http://www.access-programmers.co.uk/forums/showthread.php?t=63720

Good luck!

 

[Me!User]

Default Logon form precedes everything else. Yes? No?

Thank you for the links; however, they appear to refer to specifying startup conditions after the user has identified herself. Correct me if I'm wrong but the default Logon form appears before any code (like an Autoexec) is executed.

Upon opening a secured database you are prompted to supply your Username and Password in a default Logon form (see attached image). I want the ability to alter the appearance of this form or replace it with one of my own design.

Is this possible?

 

[o1110010]

... Logon form appears before any code (like an Autoexec) is executed.

Ah. Then I expect you will have to go with creating your own security. I know there are two threads that have samples uploaded on here. I cannot find the second post but here is one.

http://www.access-programmers.co.uk/forums/showthread.php?t=64220

(Look at post #3 at this above link.)

 

[Me!User]

Is any part of Access Security open to developers?

Thanks again.

I already reviewed the suggested example and chose not to emulate it. I agree with its cautionary opening message that a custom security scheme will not be as secure as using native Access Security. In addition, there is the burden of maintaining the custom security scheme.

I was hoping that elements of Access Security could be exposed to a developer to permit enhancements. I'm still hoping ...

Does anyone else have any information on manipulating Access Security?

 

[Parker]

Thanks again.

I already reviewed the suggested example and chose not to emulate it. I agree with its cautionary opening message that a custom security scheme will not be as secure as using native Access Security. In addition, there is the burden of maintaining the custom security scheme.

I was hoping that elements of Access Security could be exposed to a developer to permit enhancements. I'm still hoping ...

Does anyone else have any information on manipulating Access Security?

That is why you create a custom security scheme. And as for a custom shceme not being secure as the native access security? what a laugh, Access security is not secure---- even mde files can be cracked with a couple of hours work. Sorry but if you really want to be that secure then a good custom built modual can be more effective

 

[Me!User]

That's the definitive answer I needed.

Pat Hartman:

Many thanks for your answer!

I found a workaround for my burning need to modify the Logon form. I currently have a shortcut that specifies the database and workgroup file. I'll simply include the user's name with the /user switch. Yes, I'll need to customize each user's shortcut but that's not a significant drawback.

ACC2000: How to Use Command-Line Switches in Microsoft Access


I also found a wealth of information regarding Access Security in the following article:
Frequently Asked Questions About Microsoft Access Security for Microsoft Access versions 2.0 through 2000