Login Form in MS Access 2007

[iuianj07]

Hello guys,

I would like to seek help and advice on my current database:

I created a database with a Login Form as the startup form. when a user enter their username and password, then the main form will appear. That part looks ok.

My real question though would be, since we wanted to implement a login form to have access to the database is for security purposes. Is there a way that when we open the database, the only form that a user can access is that login form? Meaning that All Access Objects on the left side of MS Access are hidden/disabled until someone logged in? Because it wouldn't look right if there is a login form but someone can bypass that and open tables/queries/other forms on the left side?

Any help is greatly appreciated.

Thank you,
Iuigene

 

[BDCarrillo]

Click the windows icon, and go to Access Options. Once there, select "Current Database" in the left pane.

Select your "login" form as the "Display Form:"

Uncheck the following:
-Display Navigation Pane
-Display Document Tabs
-Display Status Bar
-Allow Full Menu
-Allow Default Menu Shortcuts

Bypass these options by holding down "SHIFT" while opening a database. You can also remove the ribbon with VBA.

 

[iuianj07]

Hey,

I have the login as my display form, my question though is, after I do login from the form, is there a way that it would now automatically show the navigation pane? Instead of pressing the F11 key?

Thanks

 

[dhookom]

IMO, users should never use the navigation pane or database window. All user interaction should be through forms.

Duane
Hook'D on Access
MS Access MVP

 

[iuianj07]

Hey dhookom,

Yes that is true, but of course there are some users nosy enough to try and explore, open queries, forms, reports that they shouldn't do. And we have told them that several times but of course some still does it, and it is hard to track down who does. That is why I am trying to figure out if there is a way to hide them until they logon to the form..

Thanks,

 

[dhookom]

I assumed by your question

is there a way that it would now automatically show the navigation pane?

that you wanted your users to see the navigation pane.

Duane
Hook'D on Access
MS Access MVP

 

[iuianj07]

Yes.. because the Project Leader would need to have access to the tables and queries whenever she needs to add/delete something to the table and run queries to see the status of the project.

No.. for the users that are only using the database for data entry etc...

So is there a way to satisfy both conditions?

Thanks

 

[dhookom]

I would create a user interface for the Project Leader.

Duane
Hook'D on Access
MS Access MVP

 

[BDCarrillo]

As a temporary measure, use VBA to disable the shift key. Set up a password prompt to re-enable it and share that password with the Project Leader, until you're done building their interface.

Disabling the shift key would be a good extra measure of security

 

[iuianj07]

Thanks BDCarillo,

I might be go with disabling the shift key, but would you be able to help me write the VBA to disable it?

Thank you and I appreciate the help.