i have two accounts on my file. one admin with full priviledges, and one guest account for data entry only. my file is to open and login with name and pw. my problem is that the file opens into the account with fewer priviledges. im looking for a change user command i believe.

thanx

travis

to change the filemaker privileges of a database you would have to log right out of the db.

The only way to protect the full workings of the database is to have two logins but use the NON full access for everything. One for full access, one read and write data.

Make sure you cannot select layouts or scripts from the menus and create a secondary login using a username and password and validation script routine. Use buttons to access different layouts that check to see the access rights.

Make sure that you have complete layouts where every field is non-entry except in find mode. Make sure you also stop the ability of deletion of records. It is always good to allow a void of a record but not delete - only admin people can delete and you could always do a search for voided items (definable by you) as an admin officer and remove confirmed voided items.

i guess my question was not clear.

how do i switch users?

when i open the file, it does not ask for a name and pw, it just opens up with data entry only account. i need to get to my admin account.

switching users between your pre-defined accounts for the databases means closing and re-opening the database - not the application, just the database.

Switching users is not like switching users in Windows XP or OSX - the only profile information is set up in the restrictions that you have set per user account. You will need to close re-open to be asked for your username and password again.

The way I suggested is to have a data entry and admin account but use scripting to give alterative access rights and limitations using a seperate login process that is defined using scripts. You would have a user table with a password and username defined in there and use this information to validate a user.

Look in the File Options command (file menu) this is where default passwords are stored. It sopunds like you don;t want any default passwords to be used.

There is a Relogin script step (I forget the exact name). Make a script with this step, set it to display in the Scripts menu.

part of my problem is i am not getting asked for a password as of today. friday when we opened the file it asked for a name and pw. now it just opens up in the guest user account.

i need a name and password screen. how do i get it when it doesnt come up when i open the file?

normally, if there are defined passwords for the admin account, it would automatically request a username and password

On a Mac hold down the option key to get the password screen, on a PC use the shift key when opening the file. The other thing to check if you are using a Mac is your keychain in utilities as it may be storing your passwords for the file.