Dear All

Please tell me how to create username and password for 10 users to logon to form in access 2007 so they can only enter data in the database.


Second problem is that I want to hide the record operations / navigation buttons form the lower bar of the form so no user can access the accounts in the database .. just only can enter records.

Sounds like you need to invoke user-level security. You can only do this on an mdb file and not the new 2007 file format. More info on my web site.



You can control what the user sees by using the startup options and by setting form properties via the properties pallette in form design view.

Adviced literature on Access 2007 Security
=> Get started with Access 2007 security
=> Access 2007 Security Options
=> Security Considerations and Guidance for Access 2007

To disable the navigation button, check the form property 'Navigation Buttons' and set this to 'No'

HTH

Greetz from Belgium

Luc aka Kuifjexx