Login Form

[bnar]

Good day dears,
i have a database with many form and reports .... i created a LoginForm that you can enter UserName and Passord then if match it opens tha MainForm,my problem is when you open the database all other objects are clickable in another word the user may just ignore the LoginForm and click on any object to view it.by the i use access2010.Any help please

[June7]

Hide the navigation pane, disable ribbon, disable shortcut menus with startup options:

http://www.addintools.com/documents/...s-startup.html
http://office.microsoft.com/en-us/ac...010226996.aspx

[bnar]

Thanks For reply...i did what you mentioned,but i want Objects accessible after entering user name and password

[June7]

The navigation pane isn't completely unavailable. F11 will expand it. Review http://www.access-programmers.co.uk/...d.php?t=176195

[bnar]

would you please take a look of attached..my question may get much clearer,when you open the database a login form opens first,,they you may enter user name an password(also you may just ignore it and do whatever yo want in the database)i want to force users to enter username and password to see the database objects.
Thanks

[June7]

I understand the issue. Did you review any of the links I referenced? From what I read it is not simple to programmatically control the navigation pane. Code can expand but apparently not collapse it.

[bnar]

Yes, i did review all links that you referenced,unfortunately did not get what i need,anyway Thanks very much for your time

[Siuxia]

I have recently made a User level log on system for a DB I have been developing, User would enter Name and password on the initial start up form, which opens a custom switchboard. Selections there are dependant on a AuthType set for each user which is verified by the Username and Password on the initial login form.
Standard security measures used as well are disabling all tool bars etc on start up, and a bypass key disabled.
I can't open the file you uploaded here, but will check later to see if anything can be done similarly.

[amrut]

I have made a couple of changes to your login form. hope it helps. If your main form acts as a switchboard then I suggest you to hide the ribbon completely.

[bnar]

Hey Amrut,thanks for the reply i checked attached zip,when i enter user name and password it opens the main form but but can not acces them as the Login Form wont go away and when i try to close it,it closes the database application,tried to remove application.quite on the Vb code of Login form but then it lets you to close the form without even entering User name and password!
Thanks

[amrut]

Ok, this one works perfectly. further, you should close the recordset after your code.

[bnar]

Thanks Amrut..it works good,i did hide navigation bar,all menus and disabled right click..thanks again for your time