How to restrict access of users with Macros?

[spencerr]

Good day!

Before I start with my issues, I would like to clarify that I am a student and am using just macros without any SQL or VBA coding.

Firstly, I have a login form right now. I have 2 users - admin and user1. It is working fine. After a successful login, it brings them to the main menu. However I wish to restrict the access of user1 by disallowing him to edit the main menu and the forms thereafter. Is there any way to do so by using macro?

[pod]

Why don't you make an MDE file (project.mde) from your project, this inhibits everyone from making modifications to it.

And give access to the source file (project.mdb) only to the admin personnel

see under Tools -> Database Utilities -> Make MDE file ...

google "Make MDE file" if you've never heard of this

[spencerr]

Hi. Thank you very much! :)