Security Concepts

Hi and thanks if you can help... (I'm using OSX 10.2.4 and FM6.04). If FIlemaker is not open and I double-click on a database that has some defined passwords and groups, the Filemaker app itself will open, but the database file will not. Once Filemaker is open, however, double-clicking on the same database results in it opening immediately. Interestingly, if I remove the passwords and groups (so there's no protection at all), then when I double-click on the same database, Filemaker will open (even if it is closed) first time every time. I've fiddled with the application and document prefs, to no avail. Trashed prefs, checked permissions, run Nortons, …

This is wierd! A system I have developed over the past four years, which has been running quite happily, suddenly won't let me modify a record if launched from the file. When I launch from the file I get a message that I do not have sufficient access priveledges. If I launch the application (FMP 5.5) and then open the file it works OK.

On FileMaker Web site i can read "Disable New Database menu item prevents users from creating new databases on their own" How can we do this Thanks.

I'm experimenting with assigning groups & passwords. One problem I have is that my databases fire automatically in the middle of the night (FM 6 files running on FM Server 5.5 on a Win2000 Server box) to go through eight hours of imports and exports. If you have groups & passwords defined, then you must enter, at least, the master password every time you open something. How can I get my opener file (that runs the dozen import/export subscripts) to open via Windows task scheduler and not stop to wait for a password to be entered? Steve Brown

i am looking for advice please. i wish to create a script 'a' which specifies an action based on which password the user has entered; e.g. if password=abc, perform script 'b', else if password= def, perform script 'c'. what i cant find anywhere is how to get the if statement to read the password which had been entered ...?? thanks !!!

I'm working on a database in which different users can fill in their hours. They should only have access to their own records. I know I can make different passwords and groups to organize this (I did it and it worked) but when the users change, I have to change the access privileges into each database (a lot of relations). Is there an easy way to arrange access privileges without a lot of editing. I tried 'gateway' but I can't get really into the program. (I can open it and see that it works, but I can't see how)

We have a Windows Pro 2000 desktop machine serving out FMPro 5 unlimited in a Uni department. We have small booking databases for car bookings and IT help requests, accessed by a Departmental web page. Since IP restriction was turned on (Windows server) to give some level of security, Macintosh computers can see, but no longer submit bookings, if using Internet Explorer, Safari or any non Netscape/Mozilla based browser. It does not matter if the mac OS is classic or OSX. Netscape or Mozilla work, IE and Safari do not. Does anyone have any idea where the problem may lie?

Post deleted by StephenA

Hi, all. Two questions from a newbie. I'm trying to set up a default password with limited access. The problem is, when I select "Limited..." from the Edit checkbox in the Privileges dialog box, I get taken to the calculation window. I'm not sure what I need to make the calculation read. Basically, what I'm trying to do is make the entire file read-only except for one field, a "Notes" field. Also, is it possible to create a button that prompts you to ask for a higher level password and can change the access privileges? Any help would be greatly appreciated. - Jesse Harlin Composer

Hi everybody, I am new to Filemaker and worked through the sample files and read some threads here. What I want to do is creating a system with three user levels. Please let me know whether my basic strategy is ok. I have a login file where I assign a password to each user and each password to a group. Depending on the login I direct the user to three login layout. From there the username is pushed to a specific start file (one for each user level). The start files open with a standard password (of course each start file has its own). By checking with a script for the open login file I (hopefully ;-) ) prevent the start file from being opened with…

I just hadFfilemaker try a default password when it opens and it was one that restricted access. Now I can't get to a new password window to enter the master PW. Where do I go? I am on one computer, i.e., not logging on from any other site or network. It's just me and my laptop (Mac OS X). Thanks if you can help, Carlo

Hi Guys, I have Hi Guys, I've created a database with record level security using the Access priviliges in FileMaker Pro 6. The formula limits the user to edit records they have created which is great. My problem is the error message FileMaker produces if the user tries to edit a record they dont have access to "This field is not modifiable". Is there any way I can display my own custom error message, as this is not useful to the user. Thanking all in advance

I'm setting up some passwords that use the Browse, Edit, and Delete by calculation. Since that is a new feature to FM pro 5.5, and vesrions below 5.5 can still open the file, this poses some concern. Is this an issue? I've searched around a bit and didn't find much. To make sure, I've put this as the first line in the start up script. If [ TextToNum(Middle( Status(CurrentAppVersion), 5, 3 ) ) > 5.5 ] [stuff] Else Message[blahb lah] close[] End If

I am new to using version 5.5 and I am wondering what happens when you leave the Disconnect from FileMaker Server when idle box checked in the Access Privileges? Will it close the table or will a dialog box show up asking the user to shut down or will the user (if away from their desk for a while) even know that they have been disconnected?

I designed a database to keep people's personnel records. There are 8 members of staff so 8 records within the database. But I want people to only be able to access their own record. I've had a look through the past messages and can't find anything that a) quite matches what I'm doing and : I understand the solution to! I've played with passwords before, but I can't seem to figure out how to do what I want in this case. Can anyone help? Thanks Nicole

This is something I never figure out. I've defined two groups - let's say Management and Staff. I've also got a list of passwords - Nicole, Laura, Aditi. Now Aditi is a manager so when she opens up the file and types in her password, I want her to be able to do the stuff I've assigned to the management group. But when I try to assign passwords to groups it doesn't work. According to my manual, you click on Access Priv/Overviews and that brings up the list of groups, passwords, etc. Theoretically you can then click on a group and then change the bullets of the passwords to asign them to groups. But in reality what happens is you click on the group and then click on the pas…

When and if an employee decides to minimize the DB but not filemaker, they can c all the related DB's. How can i keep them from pulling up an related DB?

Is there any way to restrict the access to a field depending on the result of a calculation ?

I've created a pretty elaborate dB with a calendar, medical notes, and everything, but I can't figure out how to restrict access. I've set passwords, but how do you get the computer to ask for the password in the first place? To open, I just click on the file on my Desktop and it opens with no PW request. I don't want my secretary, who uses the same computer, to screw up all my good work. I'm sure it's simple but I can't find the instructions anywhere- here or in books. Thanks for any direction.

I have a database shared on a network. 2 password: (no password), by default, and administrator password. 2 groups: admin (associated with the admin pass) and user (associated with no pass) Normally if a user log in as administrator the funcion Status(CurrentGroups) returns admin user This way I can check into scripts if the user logged as administrator or logged with no password. This work good with FM 5.5 Windows FM 6 Os X FM 5.5 Mac opening the file locally. However, if I open the file (shared by FM Server 5.5 OS 9), with FM5.5 OS 9, the status function doesn't operate correctly, and the user is recog…

I was almost sure that I could restrict users to modify a record flagged with "closed" using Access Privilege. Is it possible with FM 5.5 or do I have to move up to 6.0. I'm stuck here for two hours. I can see the option "limited" in the "Modify" Menu in Access Privilege. It leads me in a calculation box... I set it to If (flag = "closed",0,1)... or Flag # "Closed"... It doesn't work. Please help.

How can i undersatnd my solution copied to another comuter? Does filemaker undersatnd any spesific information about any hardware of the computer. (for example harddisk number) I want to protect of my files to copy. Please Help me Best regards Adam

Another bizarro question... sorry! Is there a way to set up both of these things: 1- Once a new job (record) is created, you cannot change the job number field (it currently auto-assigns when you press "New Job" script button based on the last job number for that client code) 2- Once a job is marked "Closed" and "Billed" (2 different fields) you can no longer edit it in any field, or at least have a warning that the job is closed and billed before being allowed to change any data. THANKS FOR ANY INSIGHT!!

Hi! I have a main menu for our Traffic Manager to allow her to navigate all the different layouts in the db. I want other employees to be able to view one layout only. I set up the access and password priveleges to reflect this, but I want FM to do the following: If logging in using one password, go the main menu (to access everything) If logging in using the other password, go to a different menu (that only lists what they have access to). How do I write that script? THANKS IN ADVANCE!

HI, folks. This is my first post, so bear with me if you will. I work for a residential school. We've created several related databases, including "students.fp5," which contains all the info on our kids. In this database, there are (among others) two fields, "nameClass" and "nameHouse." One lists the class a student is in (eg. class one, class two, etc), the other lists the residence the kids lives in (eg. House A, House B, etc.). I want a teacher to be able to browse ONLY the records that contain his/her students. For example, if I teach in Class 2, I should only be able to browse the records of students who are in class 2. I can't get this done for the…

I am mostly self-taught when it comes to FileMaker, so my knowledge is limited. I have encountered a security related problem, and I am pretty much stumped: I have a database (running FM 5 Unlimited) allowing users to create and manage their own accounts via the web. Problem is, this solution is not very secure. Someone who knows what they're doing could with CGI requests pull data from any record, including others' user names and passwords. Is there anything I can do to prevent this from happening? I have considered the Web Security Database, but would that allow users to create their own accounts via the web? Also, I heard that not even the Web Security …

i figured out how to set up the access with groups and passwords. i just have one problem. i set up a client account so they can only see 3 forms or layouts. i set it up so they can only create a record. and only see those 3 layouts. the problem now is that when they go to the next layout they would need to creat a new record everytime. when i gave them browse rights they could just scroll down their record so they would not have to creat a new record. but now they can see everyone elses records. just to clear it up a bit i just have a group that can only access three layouts but not other records. but i need them to have free access to their whole record they t…

Hi, I'm tweaking the access levels of a couple related databases. One is a timecard where each entry (via a portal) is a record in a related database. I have a script which is run after a timecard is filled out which goes to the related records, loops through them and performs a the setfield function and a calculation and, lastsly, "sendmail." When I run it as the non-administrator user it says "Your password does able enable you to do this, or this file is not modifiable." I can run this script fine as admin fine and I was able to trooubleshoot the problem to the "Go to related record" script step. I've given the user access to the necessary layout and fields i…

Is it possible (via plugin or other way) to get the username and password the user used to log on the computer (MacOS) or the microsoft-network (Windows) ? Users have to type their password twice: when they access the network (or when their log on their mac) and when they access fm network solutions. They don't like it..

We have been experiencing an annoying FM (bug?). Whenever we change a permission on a given password, FM changes (randomly) permissions for other passwords. It will make some fields unviewable, others unalterable. Similarly, when we add new fields to a protected file, FM assumes we want the highest security possible on those fields, and we have to go in and manually make them available to all. Is this supposed to happen?

FileMaker's shortsightedness makes me mad sometimes. I've got 30 relational databases. All use FileMaker's built-in password support. Changing passwords is a very inconvenient process for solutions with more than one database. The problem compounds when each user is given a unique password. I know there is at least one 3rd party plug-in solution that is supposed to handle this well, but I'm (or my company is) cheap. Plus I want to hold FileMaker accountable for this, as a large amount of FileMaker solutions are multi-database. So

I have 2 related databases. Database 1, with a name field that is shown in a portal related to database 2. The user of database 1 can edit both. I want the user of database 2 not to be able to change anything in database 1. I've tried to set a password on on both databases with groups and this works except on the field with the portal. This is the field I need to have restricted. Thank you Kevin

I am developping an application to be used on the same PC by several users. I want to limit the access on a record-by-record basis, so people would only have access (for editing) to the records they created. My first idea was to proceed as follows: 1 Define a text field named Record_created_by. 2 Set the auto-entry options for that field to auto-enter the name of the record's creator (choose File menu > Define Fields, select the Record_created_by field, then select Options > Auto-Enter > the Creator Name). 3 Define a password with the Browse records access privilege limited to records that match the calculation: Record_created_by = Status(C…

I need to stop editing capability on a certain field when a script is run. I present I produce a duplicate record in another db that doesn't allow access via password protection. Is there an easier way? Kieron

I have created a time clock program with 2 files, time card and time card line items. I want to limit users to creating but not changing times. When I set up a password and unclick edit records, I can still edit with that password. What am I doing wrong. I also limited access to layouts with user passwords, but then my scripts don't work since the script goes to specified layout to perfrom its job. any work arounds

I am in no way a programmer and thanks to the many contributors to this forum for your informative posts. I've set two passwords for access to a particular file; administrator and user. Admin. having full access, and I'm trying to control delete access to the users. I've reached the point where FMP is looking for a calculation formula to control delete access to records. As stated before, not a programmer. Any help greatly appreciated.

I have developed a networked requisition program for 6 schools. The secretary for each school has access to create her requisitions. Each requisition contains a product code, product description, price, etc. In Access Privileges I have denied their right to delete to prevent the loss of records. Because this file is related to an accounts balance file that keeps track of their budget balances, I also want to prevent them from returning to a previous requisition record and changing the numbers by which they could return money to their account. In Access Privileges, I know that I can deselect the "edit" feature, but this leaves someone at a higher security level to del…

Am I correct that there is no way to do a -edit URL or Form without including the -RECID for the record you are editing? If this is the case, considering that the recid is a serial number that developers have no control over, isn't it extremely easy to hack a URL and find data for other users?

HI I have a login system based on 'kennedy template and login system' - http://www.fmforums.com/threads/showflat.php?Cat=&Board=files&Number=46219&page=0&view=collapsed&sb=5&o=186&fpart=1 - where a user enteres a username and password which is working fine, but I want it to tie in with the built in password process within FileMaker. ie I have in the built in passwords user1 user2 user3 user4 Now general users will when they login will be assigned the default built-in login password of user1, but I have the need for a group to have the built-in login to user 2, another group to user 3 and another group to user4, each user p…

Howdy, folks! Is the Web Security Database re-cursive, i.e. can it be used to control its own access if it is shared through web companion? If possible, how good/bad is this idea? Has anyone done it? We would like to let web users create their own login/passwords in WSD while we assign which databases and levels of access. Publishing the web security databases (or at least the Web Users-.fp) seems suspicious, though. Any feedback is much appreciated. Solutions more so. Thanxalot!

I have a web database for my clients that I want to require two fields for them to sign in with (name and password fields). I would like to avoid using the Web Security Database for configuration reasons. What I have now is not working properly. All the client has to do now is fill in one of the fields to gain entry to the database. How do I create a login page that requires both fields to be filled in before allowing entry into the database? Thanks in advance for you help

Dear ALl, I am trying to build databases which I am going to make security on layouts,buttons,fields depends on each employees. For example, each employee has different access to each layouts,buttons ( same layout but each one can click a button other can not ..something like that) and fields. Since we have 100 employees. You have an experience about security, what you think about? Do I have create 100 passwords for each employee ...or I should control by script.Do you have any suggestions or ideas which you have experienced? Thanks

Dear All, I would like to know if there is a way to gray out the files on the Window bar ...since If you clikc at Window at the top, it will show a list of files related ...How can I make it protected so people can not click on the files at window at the top? Thanks

Well, for some reason Created By or Created On fields have no data in them. On Wed some 300 records and duplicates maraculously appeared in a database, which is served on FMS 5.0 from Windows NT Workstation. I am trying to hunt down how this happened, or who created them, and was hoping to avoid digging through Events Log by simply looking at Created By or Created On fields. But they are empty. How can I find out? Thanks

After implementing a calculation for browse records privleges I noticed a HUGE slowdown when users open my hosted database file. I assume this is because when the database is opened there is a initial find taking place to find records with which the user has browse privleges. I only have about 300 records in my database file, and I cant imagine how long it will end up taking to open the file when there are 3000 records. Is this just the nature of the beast. IF so, YIKES! How do users deal with this? I cant imagine a solution with 30,000 records. It would take an ETERNITY to open the file if there are any browse record privleges set. LR

Need example or information how to control different access level in Filemaker and how to organize the group, password and access I know a lot of question

how can we do in filemaker for the capitalise(caps lock) either taking in consid

I have a number of files. I navigate through them with a simple script that hides the current file and opens or goes to the desired file by clicking on a button. I've now set up passwords, programmer, systems manager and TA in each of the files. I used to be able to click on my button and it would take me to the desired file. If the file was already open, it would take me to that file. Now that I've set up passwords, it asks for a password as I enter the destination file and opens up another window of that file if it's already open. For example, if Contents is already open, clicking on a "Go to contents" button in another file asks me for a password and opens anothe…

I'm running Waves In Motion's Security Manager 1.02 through it's paces. It looks really really good so far. Has anybody put it into action? Is it as good as it seems?

I have numerous filemaker files which are protected by default passwords. All files are hosted on one computer and accessed across a network. If I wish to get into a specific file from my computer, which inot the computer hosting the files, I use the shift key to bring up the password dialogue so that I can enter the developers password. Everthing works fine, except that one file will not give me the chance of opening it with the developers password, it always opens in the protected format. Now- if I go to the hjosting computer I can get the Shiftkey/ Open funtion to work correctly. Anyone got any bright ideas! As usual, help would be mich appreciated. Regards, …

I was wondering if there is a way to have my solution exit or request a password if it has been sitting idle for ten minutes? I want this to prevent lower level users from changing anything. Thank you Kevin

Can I change a password in a file and this new password will be the new one in each files ? I want to create a script that will change a password for all files. Right now, I got to open each file and change the password.

We are primarily a Mac shop. I have been running a database solution in which is hosted on one of the Macs here and is accessed by 5 client computers. We just recently added a PC. I noticed that when I open the hosted files on the PC all the related files show up along the bottom of the screen. This makes it a bit confusing to the user, especially if they click and open one of the related files. Is there any way to NOT have all the related files show up along the bottom of the screen like this? From what I have seen there is nothing to be done about this. And also, why is it that if I have a startup script with Status Area Hide [Lock] as one of the items, and i…

I was playing with some calcs for the Browse Records section of Privleges. Something like this for comparing one field to another seems to work: If(gGroup 1 = Group 1, "1", "") Or a variation like this works: gGroup 1 = Group 1 But when I try to do multiples like the following it does not work. If(gGroup 1 = Group 1, "1", "") or If(gGroup 2 = Group 2, "1", "") or If(gGroup 3 = Group 3, "1", "") or If(gGroup 4 = Group 4, "1", "") Any tricks to get this to work? I tried replacing the "or" with "&", but of course that will not work because then all four would have to match for the calc to work. I am trying to set it up so that if any …

I am trying to give some 70 or so users access to their own record in a database. My method is: Give a single password to all 70 users. That password has the "Browse records" and "Edit records" Privileges set to "Limited..." with a calculation that matches a field in their record with a global that they enter on opening (e.g., "userEntryCode=entryCodeGlobal"). This method works as far as allowing them to browse only the matching record. But when they go to edit any field, they get the message: "This field is not modifiable." even though the field is modifiable and they are in their own record. What is the problem here?

I have a large relational database. One of the databases within it is an archived database that should be read only. We host the file on a server for referencing but do not want the users to be able to modify it. How can I set this particular file to view only? Also, is there a way to make it view only to certain passwords but writeable with othes.

Hello, I have a filemaker database which has recently run into a major problem. It is a version 4 database, run on FMP server. The problem is that the database has stopped accepting passwords. It will not accept any of the passwords, master or otherwise. I have tried recovering the file with FMP several times, as well as running norton disk doctor on the machine several times. Neither process has yielded positive results. I have also tried password "peeking" type programs and they do not reveal any. I suspect that the password section of the DB file has become corrupted catastrphically. To compond the problem, the client's tech stopped backing up the machine in septem…

Is it possible to restrict access to all files being hosted by fmpSERVER? So when the user clicks the host button the files that are being hosted are not accessible until a password is entered.

I love FileMaker as much as the next person, but every now and then you come across something and wonder what they were thinking. Example: you set the available menu commands to edit only, thus limiting users from creating or deleting records along with other menu commands that are not related to editing. BUT why in heavens name would they include the ability to perform new find requests, duplicate find requests, omit find and the like with this. Would not "Find" functions be considered part of editing a record? LR

Dear All, Can we lock a field depends on other field. Example If Field A is nul then lock field B ( can enter data). If Field A is not nul then we can enter data in field B . I don't want to use passord. Is there a way? Thanks

Here is my situation: I have just recommended that the company I work for upgrade from 5.0 to 6.0 to gain the record-level access privileges functionality in our database. The reason for this is because we are going to be allowing independent contractors access to areas of our database via Citrix. The record level privileges would provide security to make sure the contractors only view the information that they are supposed to view. The record-level security is nice because it filters portals and value lists so they only see information they are supposed to see. Now the caveat. We currently have 10 db's, the main one that the contractors would mostly …

Anyone know of any good examples of a password database system. Basically, a database file that holds passwords. A main file that, when opened, you have to enter a password. If it matches a password in the related file, the user is granted access to the file. LR

Is this possible: I have a database solution that I want to distribute. I want a master password that only I will know so as to lock out others from getting into the meat of the database. I will then have a second password that will give limited access such as define value lists, basic layout changes and the like. But I cant figure out how to have this second password to allow the user to add other users and to set their access priv. while at the same time not allowing access to the master password or to its privledges. LR

I made a bit of a boo boo. I set 2 passwords, one with full access, and the other with restricted viewing and actions. Now all was well, until I set it to automatically try the more restrictive password first (for remote connections). Trouble is, I now can't add / see some 'staff members' in this database, and I do not have privilages to stop it from trying password. Any ideas how to get out of this boo boo? Thanks for any help you can give me.. Rich [email protected]

No One Knows My Wireless Woes Download the full article at: http://www.fmwebschool.com the article is called "Protect Your Wireless Network" If you are a FileMaker developer setting up a home wireless network, or a wireless network for a client, there are some things that you should really be aware of. Hackers used to use a technique called war dialing. Hackers would set modems to dial every number in town in search of other modems connected computers. Now with the age of wireless systems the hackers need not work so hard. Armed with a wireless-enabled notebook PC or a PDA and a copy of NetStumbler software for detecting wireless networks anyone can easi…

Is there a function or tool for just type a password , we can access few databases not just one databases? Thanks

I have a small appletalk network. Box A runs FMPUltd5.0. All databases running on Box A are set for multi-user hidden. Under 9.2 I used to be able to work with these files from my office computer - running FMP5 - via file sharing. Since switching to OSX when I try to open a file that is already opened on Box A I get a file not closed properly message, then a warning that says the file can't be opened as read-only in its current state - unlock the file and open it and close it before attempting to lock the file again. What the hell is all that about? I can open Box A database files that are not currently open just fine. Any ideas? Please do not suggest upgrading to 6.0. I…

Hi I'd like to get some feedback on setting up ssl to secure a filemaker pro solution. I need to secure an application (we use WC not Lasso) with SSl, secure certificate... The database and front end has been already developed (not by new!!) and contents secure information (pass, login and student marks) that could be easily be downloaded with webcompanion alone. At the moment we are running filemaker unlimited 5 on an old beige g3. We are setting up the new box running Jaguar (mac osX) and unlimited 6. Filemaker (http://www.filemaker.net/products/fmu_features6.html) says that unlimited can support SSL Is there any doc out there to help setting …

Hi, wondering if I can get some help with this. An old employee of ours locked our databases so his replacement couldn't modify it. Is there anyway I can bypass this? Thanks, Kermy

Dear all, does anyone know a method for a user accessing through the Web Companion to add a signature to a record which is secure to that user, i.e. is evidence that the user has seen and approved of the record content on the data of the signature. The signature itself does not need to be a graphic, and ideally will be a radio button, but does need to be authenticated as orginating from a specific machine (or user). Cheers, Dave

I created a database for a client last year. One of their techs password protected it. He had an ugly falling out with the client and was terminated on bad terms. Of course no one knows this password. My left brain says "of course not, that's what passwords are for", but my right brain asks is there any way to get in without it? I have to try and ask... Kay

Hi, I'm not sure this is exactly the right topic in which to post this question, but here goes... I have a field for social security number. Because the database is being hosted over a network, I want to make that information as secure as possible. I'd like to have the entered ssn show up as x's or bullets or something that masks the actual number. Then I'd like to have a separate password that allows access to that information. When I tried to set up a mask for the ssn, it would show up as x's, but if I tabbed into the field, it would show the number again, so I must have set that part up wrong. Thanks in advance for any help you can give…

Does anyone know a simple way to copy protect a database? I am going to be selling a database (multiple files) I created to several people and was looking for a way to copy protect it. I know I can use passwords and lock everyone out, but I was looking for something more. Any suggestions?

Don Wieland kindly gives out a user password system at: http://www.dwdataconcepts.com/dwdctips.htm Looks pretty good so far. So what are the weaknesses of this system? What are its vulnerabilities? Why should I NOT use it? Do others use similar approaches? Thanks!

Hello all, I'd like to give my users the ability to create new layouts, but I don't want them to have access to layout mode of any existing layouts. From what I can tell locking one option means locking both. Is there any way around this? Thanks in advance, Leah

I don't want to limit access to the database, in general. Anyone who can login to my OSX Macs can access the database. HOWEVER, if someone changes something improperly, I want to be able to determine who made the change. Does FileMaker offer any simple way of tracking who made what changes, at any level or granularity?

I created a set of related files in FMP 5.5 and established access privileges and passwords for various level of access giving myself full administrtor privileges. When the files were moved to a server running FMP 5.5 server my administrator password is now treated as a guest and I cannot see the menu option for changing access privileges and passwords. Also, the "change layout order" is grey not allowing me to make chages. I called FMP tech support and was told that I must remove the files from the server to access adminsitrator privileges, make the changes, and replace the files on teh server. This seems rather crude for such an otherwise robust DB. Help.

I'm setting up a custom password access system. I have an employees database that holds userID, password, and access privilege codes. This, and the files that I'm protecting, are made with FM5 and hosted on FM server. I just discovered the other day that anyone can start a new FM file and import userIDs and passwords from the employees DB with no problem at all. I don't see any built-in FM way to stop this, so I figure the best way to prevent any problems is to store the passwords in encrypted form (some of our customers want us to start doing this anyway). I figure I'll use a calculation field to encrypt a "change password" field, then use a script to set that calcu…

Hey all, I'm working with a multi-user database and use individual passwords for each person. This not only allows micro-management of user access to certain fields and whatnot, it also allows me to customize the user experience, such as auto-entering their personal user initials, phone extensions, email addresses, etc. I very much like this user customizable system, but I have to rely on the Status(CurrentGroups) function for my relationship to my Users.fp5 database. Because I don't have "groups" in the traditional sense of the word (each "group" is really a user name), it would make a lot more sense to me if I could simply find out the password that the pers…

I setup a startup script that automatically puts in the default password when the database is opened and it has very few privileges. How do I force Filemaker to prompt me for the master password which I have? It seems like this should be simple, but now everytime I open my database I'm stuck with the default permissions. Please help!

Hello, Does anyone have experience with record locking through FM server hosted files ?? I created a file where i put record acces through a calculation field. Why ??: because i can edit this calculation without having to close the file on the server. I only have to disconnect all the users on that file. In this calculation i put some references to an other file (i use a separate file with all my usernames and put into some fields what they may do or do not.) This was working verry well without the record locking but i had to put calculations on every field. With FM 5.5 i can use record locking so i'm now replacing all the old program codes with this, so now i'm real…

With Filemaker 6 I can have a field called modifier name that will always show the last modifiers name. But this modifier name is the name that

Hi All, I have this file that has 5 users,i would like to be able to track which user has changed or modified a record as the file contains sensitive data. I created passwords based on the groups(5) I then had this set up in a script set field(user),status(current groups). The strange thing is in the user field..all the groups are displayed instead of just one group.(nb: each password is a member of just one group) Where have i gone wrong? anita

Does anyone know of a plugin with a function that, passed a username and password as parameters, would authenticate (and do nothing else) that username and password in a Windows 2000 domain? I understand that I can authenticate the user when he/she logs into FileMaker, but I need to authenticate again for specfic functions to ensure the user hasn't left the machine on etc. I am trying to create a sort of "electronic signature" and, rather than build it through FM, if I could just show a custom dialog (which I understand how to do) and pass the collected info to a function that returns a boolean indicating whether the username/password successfully authenticate, I can pr…

Before I put a file on the host ..I did not make password with it. When I put on as the host. It is disable the file-Changepassord ...eventhough I did not see Access-privilege ..How is that happen? ..how can I change it to Access-privilege? Someone have ideas? Thanks

Hi All I would like to know If I protect a field ( can not touch that field when click on that field) in browse mode ...but when in Find mode I would like to search on that field but that field is unmodifiable ...So how can in Find mode I can put it as modifiable? IS there a way to do that? Thanks all

Dear All Is there an example that I could see about record-by-record protecting or any kind of example related to protecting by password since I read the book and have no idea how it works? ..Groups and password ?? I really need your help Thanks All

Hello folks I have an old database that is not in use, but now I want to edit something in it but i don

I have two related files - File A contains layouts with related fields and scripts performed by buttons; File B contains the data; the relationship is based on record numbers which are in both files. On startup, File A also opens File B. The user then presses a "start" button that runs a scrip that finds all records and sorts them. With no passwords in effect everything works well. However, if I define a passwords in both files that limits the user to Browse, Print, Export and Edit then when File A opens and I press "Start", I get error message "your password does not permit you to use the current sort order and when I look at File B all the fields are filled with hat…

How can I ensure that the FMP user name is set to the system name and not a custom name? I think I can get by with just three passwords: Me - master password Edit - people who need to edit the data View - people who need to see, but not edit as long as I can ensure that users can't fake their user name. (I will keep an audit log of every change and who make it, preventing anyone from being "bad' without getting "caught".) We are running OS X, so users must be authenticated to even use the computers. Thus, I *think* if I can restrict it to the system name, that I am safe. True? I have one user who wants to connect from a PC. What wou…

Hi filemaker pros i need some help here .... Im realy bad on calculations /scripting but i do the best i can to learn i have a customer system that is based on 6 different fm 5.0 dbs all databases get company info from a system database. Now i want to have a expire date thats checks if the date is expired. Ii have made a field in that system db called expiredate and i need to check if it is equal to today or less ? and take action to that ...depending of the result. one nice solution is if it is posible to switch the login user if the date is passed and then set that user to read only. or does i need to kick them out with some msg telling them to uppdate ?…

This Crypto Toolbox Plug-in.fmx was working for couple of minutes in FM 5.5.v2 and then it crashed FileMaker. Now it is not working at all. W2000 SP2 Anyone with feedback?

Getting into the 'access privileges' things rather as a newbie, I started yesterday experimenting with this section.. My intention was to make some lay-outs editable (the MailMerge lay-outs used for printing) and the other lay-outs non-editable. In other words, some with lay-out mode accessible and the others not. As far as I experienced now, this is not possible. You can define for each lay-out the accessibility in browse mode (complete, read only or not at all), but the lay-out accessibility in the way of the Filemaker lay-out mode is a ALL or NOTHING thing. I'm correct on that? Or are there bypasses? I could imagine that putting the lay-outs with lay-out mode acc…

Is there a way to allow a user to create their own password in a runtime solution?

Dear Gurus and all users, I need to recognize users’ passwords as they log in to the database working on a one single computer. So I have few users and one single PC. Depending who logged in I want to perform a certain action – like automatic signature. It is easy in programming languages, but how can I do that in FileMaker? Appreciate your support, Robert

I am trying to imitate the password dialog box where an individual would enter his/her password and the system would log this. How do I graphically achieve this - the user entering their password without seeing it, yet getting the feedback of a circle appearing in the text box they are typing in?

All, Can you 'automatically' enter a protected DB with an established password? Here's the situation ; I've created a 'Login' DB that identfies the user through a login name and user password. OK This procedure also identifies the user's 'FM' password. This is a shared password that is used across a number of DBs. That is, various users have this password to access various levels of the DBs. For all users [except admin] this 'FM' password is not seen. The 'FM' passwords are consistent across all DBs What I would like to do is have the 'Login' DB open a 'Main' DB with the 'FM' password. This would be achieved without the standard password requireme…

We inherited an FMP kiosk application. from a defunct company we bought. The app and its files appear to be locked and/or password protected. We are trying to get inside the application. Need some advise and help here. Are there any FMP 3rd party apps that we can use to open this application up? It was done using FMP5.

I've got a FMP 5.5 database using a custom web interface. I am using the web security db to limit user access, but the way the web interface works, there are several different workflows (i.e. create new record, edit record, approve record, search and view, etc.) My question is this: is it possible in FMP to limit users access on a workflow-by-workflow basis? And if not, where should I start looking for answers?

I have a problem and I am really stumped. I created a security access file to be used to open my other databases in FMP 5.5. User name and password as well as privilege levels (restricting what layouts in the databases) and a site number (restricting which files they can access) can be set up by the customer server manager. There are 8 general levels of access which are FMP passwords that are entered by the user on opening the access file and they are passed on to the other databases when the files are opened. I created a catenated field in the access file putting all the information I needed in the main database together in a field. It is then set in a globa…