Having a log in type deal.

[CodeCracker0291]

Ok, maybe this is difficult maybe it's a piece of cake. What I idealy want is: Have a switchboard with a couple of choices. View Info, Edit Info, Exit

Ok with the View Info button I want the searches to come up and only be able to view it...almost as it was locked...

Now the Edit Info button I want if the person to clicks it they have to enter a password for them to go any further. Therefore, making it that only the necessary people would be changing the info.

Just to clarify, there's only one computer and only one user so far. I just want them to be able to only change the info by clicking Change Info and typing in a password.
Thanks
Jerad

 

[neileg]

Yeah, not a big problem. You could use Access security to do this, but its perhaps overkill.

Ok with the View Info button I want the searches to come up and only be able to view it...almost as it was locked...
This button should open a form that displays your data. Set the form properties for Allow Edits, Allow Deletions and Allow Additions to No. This will make the form read only.

Now the Edit Info button I want if the person to clicks it they have to enter a password for them to go any further. Therefore, making it that only the necessary people would be changing the info.

For this you need to create a password form that requires users to input their ID and password (or perhaps just password). If the details match those held in a table, then open a form that allows data entry and editing. How much security you apply here depends on you. Search this forum for a variety of password options.

Once you've set this up, you need to hide all the menus and the database window so users can't simply edit the tables direct. There are ways to defeat this hiding process, but there are also ways to prevent this, too. Discussed at length in this forum.