Macro for startup??? (1 Viewer)

[crann]

Hi,

I hope someone can help?

I am fairly new to access, i have created a database for work, everything is fine, i have set up security, so that users have limited permissions and admin as full permissions (admin is the owner of the database) so passwaord are required on login that's fine.

i have created a custom menu bar and want it to open on startup for my users and not for myself, do i have to create some knid of macro and how i have not built one before, need some step by step instructions if poss??

Once created can the users just hold down shift to re-access all the built in menus, if so how do i stop them???

Really need some help with this, its been bugging me for days..

Grateful of any help

Jon

 

[Nouba]

the user admin (the default user) shouldn't have any rights on the database, otherwise the db could be opened and changed from any pc with Access. For more information look at Frequently Asked Questions About Microsoft Access Security for Microsoft Access versions 2.0 through 2000.

nouba