passwords for Filemaker Pro

I have constructed a Filemaker Pro database, and I want to have more than one level of password access. I so far have been able to set up for two passwords with two levels of access. But the lower level access password leads to a blank screen that says no access. My question is how do I give limited access(not let the user define, fields, change layouts ect...), and still be able to use the database?
DLR
dlrAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dlrAuthor Commented:
Adjusted points to 210
0
pxhCommented:
I think this is possible. You just open the menu FILE and select Access Priviledges (or so, I have a german version, so I can't tell you how the menu item is called precisely, please use your intuition). Anyhow, there are 3 submenues: Group, Passwords and Overview.

I give you an example procedure:

Go to group first and enter an arbitrary group name. Then continue to password (you can do this directly from the Group dialogue). Specify one password then press New. Then press New again, but with an empty password field. You can now already assign global priviledges to those two passwords (empty (none) password being the second). Do some modification, e.g. dissallow certain operations for the no password access. If you continue further (there should be a buttom titled "Access" or so) you get an overview and there you can assign access priviledges even for individual fields or layouts.

Once you have done this, close and reopen the database. You will be prompted for the password. It also should allow you not to enter a password, which will then limit access according to the settings you have done.

I have verified this with FileMaker 3.0Dv4 right. However I have configured a database a while ago with FileMaker 2.x. I don't think it was too different earlier.

Yes I realize that you tried something similar already. I cannot reproduce what you described. It was easy for me to manipulate a database to allow different access levels, but still be able to access all data read-only. I can only speculate that you unvoluntarily dissalowed to much. Check in the overview. There are 3 kinds of bullets: one for read/write, read-only and no access respectively. Also check in the Password dialogue, there is a small submenu, which allows you to set avialable Menu-Commands, from normal(all) to none.

Maybe you should also remove all access control and start from scratch.


Hope this helps, don't hesitate to contact me. We could even exchange a sample database by e-mail, which I modify according to your wishes.

Peter <pxh@mpe-garching.mpg.de>
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
System Programming

From novice to tech pro — start learning today.