Security Concepts

How does one access a "restricted access" layout. If the option to "Layout" is not allowed, is there a "back door". Thanks

I have created a script, which creates a new user account using

Have a small report card database - students file and report card files. I have kindergarten teachers directed to a specific report card layout based on their log in. They enter in Find mode and select their teacher name from a drop-down menu and "find" their students. How do I restrict that so the kindergarten teachers can only find their students and the primary teachers can only find their students. There are four kindergarten teachers logging in and 10 primary teachers into a database of 400 students. I don't want them to have access to all 400 students, only their own. Any help anyone can give, I'd appreciate it. I am new to FileMaker; and using 6.0.

HELP!! On a cross platform network when a Macos user tries to modify a record in use by someone using a PC, the user gets a message saying: - "[password] is modifying this record. You cannot use it until [password] is finished. ... thus broadcasting your password to all and sundry ! It's not a problem the other way round, as the PC user is given the MacOS user name, not the FMP password. Can anyone tell me how to patch up my defences ... quick. Mike

Using FM6 on both Mac and Win I'm looking for a way to lock users from scrolling through records. 1. Is there non-script way of permanently hiding the status area from users? 2. Even if I hide the status area, users can scroll through records using the rolling button on their mouse. Is there a way to prevent that? Note: I need to have it done some other way than by limiting resultset to 1 record Thank you

I have created a database in FileMaker Pro 7 with 3 layouts. So far, I have 2 levels of protection: a

I know this has been discussed time and time again but i am still unclear about what to do. Here is my setup. I have a filemaker 7 database with various tables. Users should be grouped into teams and should only be able to view their teams work. There is also the possibility that i will include other databases at a later date. I therefore only want to enter the users and group data once. My questions are as follows: 1. How do i limit access to a users group records using FINDS? I do not particularly want to display the 'greyed out layout no access'. However, i would like a user to be able to use the standard navigation and menu commands. 2. Do i have a sepa…

VERY new to FileMaker - basic report card database and I'd like to restrict primary teachers only to the primary layout, without being able to access the kindergarten layout. I have one splash screen; one students file; one report cards file with four layouts. I'd like the teachers to only be able to view 2 of the four layouts on the report card file. How do I do that? Thanks.

If I am trying to restrict record access by calculation, I assumed that the users would only see the found set of records I restrict them to. Instead, they can only see information for the records I choose but see No Access on all the rest of the records. This makes for an ugly interface. I tried creating a filtered TO and evaluating the calc from that TO but it keeps crashing the database. What am I doing wrong?

Is this an account/privilege problem? I want to edit a (global) field but I am unable to do so in a web browser yet I have no problem in FileMaker itself. I gave full access to guest and even tried to login as admin but still can't edit anything. Please advise BK

OK, how do I do this (restrict access to certain records based on the user) in FileMaker 6? I have 8 or 9 users and we all have access to the same "contacts" database. However some of the contacts are "personal" or "private" for some individual users. Others (most of them) are general contacts that can be accessed by all. I currently have a field with a dropdown that indicates which user the current record belongs to. With one of the options being "ALL". Is this the correct way of going about it? AND (to re-cap my question) how do I setup limited access to records based on the user login in FMP 6?

Is there anyway to have a script disconnect any users with the file open? I have a file that is used by about 6 people during the day. Inevitably one of them is always leaving the dbase open when the leave for the night. So this messes up my maintence and backup that runs in the early morning. I have tried to stress to them the importance of closing the file, but they forget.

I set up a find page with different global fields for entering search criteria. I have problems in setting access privileges to users. I want to restrict users from editing and deleting the records of the database. But once I removed the privileges of Edit records and Delete records, users cannot enter search criteria on the find page because it prompted with an error message of "The field is not modifiable". How can I set the access privileges in this case?

i don

I'm a newbie at FM7. But making a field required (not empty under validation) traps the user (account defined as a Data Entry privilege) in a loop where data must be entered. What if the user accidently decided to get into this browse mode layout and decided he/she wanted to cancel and not add a new record? Does all this have to be managed from a script level? My 'cancel' button to go back to the Main Layout is preempted by Filemaker's Error Dialog Message. Any info appreciated. thanks

Hey all.. Does anyone know of any easy way to centralise the Usernames and Passwords to one file in a database? When you migrate its really painful and if you have 20 files, you have to log in 20 times... its causing untold pain at the moment. ...Skeeve

When you deny an action to a privilege set (such as non supervisors can not modify a record whose status field is "submitted") and the user attempts to perform the action, FM shows their generic message "Your access privileges do not allow you to perform this action." Is there any way I can put up a custom message when this happens, so I dont have a bunch of users wondering what it means....I would rather show a message saying "You can not modify a submitted record." or something like that.

I'm fairly new to 7, so please forgive me if the answer is obvious. I have built a database and then a second to act as a UI. I have encountered a problem. What I am trying to do is have the user log into the database with their full name. Let's use Joe Schmo. I have created an account called "Joe Schmo". What I am trying to accomplish is to auto enter into a field the account name - last name first. The result would be "Schmo, Joe". Here is the calc I'm trying to get to work Name = RightWords ( Get ( AccountName ) ; 1 ) & ", " & LeftWords ( Get ( AccountName ) ; 1 ) The calculation seems to work, but no matter what account I am lo…

Is there a way to limit access to certain records based on the logged in user? Example: I have a grade database with 2 sections of a course. How can I give 1 TA access to one of the sections and a second TA access to the other section, without having to worry about 1 TA changing the other's grades?

Hi there: I am creating a storage locator database which takes users to a List Layout once they do a find, and then the individual Record Item (which has each field formated to not allow entry) layout via an invisible button, when they click on the line item. From the Record Item layout there is a button to Edit Record, which navigates to an Entry Form (which does allow field entry). I've created the script as follows to check Status(CurrentLayoutAccess) and to deny entry to those who don't have rights via access privileges to the Entry Form layout, but it's not working. Set Error Capture [ On ] If [ Status(CurrentLayoutAccess) = 0 ] Show Message [ Buttons:

Hi- I have a database in Filemaker Pro 7 on Windows XP. I have one account set up in the Accounts & Privileges that has the built in read-only access. It works like I want it to. When that user accesses the database via a browser and the instant web publishing, the user can read all records and perform a find on all records, can't delete or edit anything. I have another account set up that is configured to only view certain records as defined by the View limited records calculation of: department = "ger" or department = "fre". The user can only view records where the department field equals "ger" or "fre" using a browser and the instant web publ…

Hi all, We are running a DB with FM5 which has a password when you open the database. I've installed a trial version of FM7 and when I open a DB it upgrades it then asks for a username and password. The original password no longer works, does anyone have an idea about this. We have never used a username before. Thanks Matt

I know its possible to force the password screen for a normal database when you're opening it by pressing option or apple or something. Is there any way to force a password screen when a database opens a relationship? The problem is it isn't asking at all when it should be. The related database IS password protected, but FM is just ignoring that and not displaying any of the related records.

I created a new FM7 file, and for the time being, have a single full access user setup, with PW. However, I can open and close the file without providing any authentication, the login dialog is not coming up. The account name is the same as the FM owner name, if that makes any difference (but why should it?). No change if I quit FM or logout. What am I missing?

Oh, for the life of me I've looked and looked. I practiced on vs. 6 before we bought 7 and 6 had where I could say a calculation needed to be true and if so someone couldn't change it. It had all kinds of things. I have been all through accounts and privilegs and can't find it. I swear I looked everywhere and even help won't say. I created extended privileges and still nothing more comes up. I feel silly asking because it must be there somewhere but I need it really bad.

Hi, new here. I just found this place because I was looking for something like this. I have three dbs in FM, but they're all password protected. It's probably the same password, but I'm not that sure. I need to get access to these dbs, but I don't have the password. I work with publications, & these pubs were entered into the dbs. Then that info was put into an HTML file & uploaded to the group's website. The group would like their pub website updated, but I need to access the files for that. That info hasn't been updated since the woman who last worked here retired (there's been 3-4 temps in the interim, but I doubt they even touched the dbs). I think it's …

Hello all, I was hoping that someone could point me to a location to learn more about record level access with filemaker 7 on the web. I have a db that I would like to clients to login on to from the web to see the progress of their projects. The client would click on their project id and then be guided to only their record. a find feature seems like it would work, but I would like to have it passworded and secure. thank you in advance for any help that can be provided. Have a great day.

What I have is multiple databases compiled in Developer to make a program we give to our agents. What I need is for us to send a text file to them (along with the ones we already send them with their data) and checks that file for a code (or anther form of data maybe) and if it does not match exit out of the program. I am not familiar with Developer to add another database to the application to handle this. I am following behind someone who left that created this product. Does anyone have any ideas of how to do this? I do know how to import that file into a field without changing how the database already reads data from another text file.

I have one more question if you please. Networked 3 computers directly (2 users and one host). They have Opener file. There are many things which happen at startup. If I put everything in the opener, those things won't fire if I open when the host is opened first, so I need startup script (set auto through File Optns). I have layout change, window size, setting globals, plugin registration and setting of certain preference fields. How do I combine these beginning settings when there are two ways in which to handle them (2 ways in)? It's like I need my own opening stuff when directly accessing but I can't add the Opener script to startup; and the Opener script needs…

i'm developing a web based application using fm7 and i want to know if there's a way to prevent multiple simultaneous login using the same username and password? regards, clifford

I once set up a read-or-append-only access to a file (in addition to a password that provided complete access). The idea was that "ordinary" users, opening the file with no password, could browse existing records or add new ones, but not edit or delete existing ones ones

Could someone assist me in creating a script that does a loop with a create account step in it, that generates a random account name. Also an assist on attaching a privilege set. Thanks

Hi, I've just installed FM Mobile 7 and now I can't perform a replace. When I find / replace, it find the correct fields but gives me the message "some fields / records could not be modified becaude they were in use by other users or your priveleges do not allow you...... 27 records were skipped" I /think/ that I have the priveleges, as both admin and guest users have full access, so I think that it's something to do with FM mobile, but don't know enough about it. Cheers

Hi, I'm desperate here! I've installed Filemaker 7 mobile and now I can't access my database. Worse, I can't find my backup. I tried to do a find and replace, but couldn't because I didn't have access (I'd set no passwords, hadn't played with users, and assumed it was FM mobile somehow. I looked at the access menu and was logged in on a guest account, so I changed the tick box to Account name which was the computer administrator, assuming the password would be my computer admin password. It isn't though - I've tried every password I've ever used and also "<no password>" and "password. I always get the message " the account name and password yo…

Hi. I'm trying to limit access to records using variable A "or" variable B.... but when I add the "or B" part, all records become visible... why? What can I do to make it work? I have "FIELD = "44" or "56" as my syntax.

filemaker states that you can synchronize with runtime applications created with FileMaker Developer 7, however i notice that i need to have full access to the runtime database before i can do the settings in fm mobile. doesn't this defeat the purpose of having a runtime database since anybody with full access will be able to modify layout, delete and add records at will? how can i create a read only runtime database, then transfer the database to fm mobile? regards, clifford

I've been working on a rewrite of an FM6 solution into FM7, getting all the structural components incorporated, and really have only started looking at the new security features. I would like to be able to have users be able to create records in a certain table, but restrict access so that they could only edit records for, say, 30 days after creation (and after that, they would be "frozen", except to someone with more access). I've been looking at how privileges are set up, and don't see any way to set up a calculation to test for the 30-day limit, as you could with FM6. Is there a way to do this?

I have a database (1 file with 2 tables) which I plan to make available on my website as freeware for others to download (using FM Developer 7). I know I must get familiar with the Accounts & Priviledges section of FM but there are no books out yet for version 7. Here are some questions that I have run into: 1) I have two tables in my database: one holds all the data and things that the user needs to access while the other just holds the "help file". Can I lock down the Help Table so all they can do is view it and not modify the record I made with the instructions for using the program? 2) I want to release this at first as a beta and there for want to put s…

I think I found something kind of bad in FM7 regarding record level access privileges.... If a user is allowed to create records but not to edit them, any records created by that user do not obey editing privileges for any user for the life of the record. However, if a user is given create privileges, but severely limited in their edit privileges (put a 0 in the calc dialog, effectively the same as no edit privileges) then the record behaves as one would expect. When I discovered this in the solution I've been working on for the past few months, I was quite upset as I thought this could indicate file corruption, and I wouldn't know how far back to revert to co…

Hoping someone can help... My Mac crashed and I lost a drive, but I was able to recover my FP file. However, when I try to open it, I get an error (#808) saying that the "access privileges were damaged or tampered with" (and subsequently won't open). I think that the data is okay in the file, I just can't open it. Anyone know how to get past this? Thanks!!!

I hope someone can help a wretched soul. I converted a FMPro 5 file to FMPro 7 successfully. I then added a password, but, perhaps foolishly, changed the Account Name and Password. I know what they both are but no matter what I try, I can't seem to open the file. I have re-created this problem with a second and third "dummy" file, and the same problem occurs, demonstrating the level of idiocy I have achieved. Can anyone tell me the secret to opening my file??? Hopefully but still shamed

I have a combined IWP and FM7 client solution for scheduling and resource usage tracking. I am not using FM Server now since I want to use IWP and server advanced isn't out. (Also I have a small group of users.... 3 different resources that each require a FM client and about 80-100 total users that must schedule their usage over the web.) The 5-session limit isn't really a problem since scheduling time is fast and I put a 1 minute idle timeout in the prefs. What I am doing is disallowing access by the full access account over web or fmnet using extended privileges. I figure then even if someone gets another password, they can't change the structure and can only d…

Hello, I want a login verification, even when the user is "All Users" is filed in the web security database. My problem is when I use "All Users" in the Web Security database with only read capacity they are allowed to go to a find/add section/html page in my solution. At the moment the user (All User) wants to add a new record the login verification pops up. I use a URL that ends with -find or -view. Is there a way that I someone want's to go to the Find/Add page need to login to enter this page? Greetings, Jukkie

I have a main password that controls everything. I went in and changed one of the users access privleges, and now instead of access priveleges showing up in the file menu, change password does. Help! How can I get into the access priveleges again? what happened? Everything else is still working fine (I have access to everything else in the menu bar.

I have several working dB's for clients, using FM 5. They're published on the web using HTML and CDML. They all have the same problem, but I'll use one for example. I have set the Web Security up to have username "All Users" (with no password or permissions) and the other username and password with browse, edit and create privileges. When the client first accessed the dB it requested his username and password. Now he can access it without going through "Log In" by either using the "Back" button or by a link from his favorites. I don't want the dB accessible without Logging In. I can replicate the same situation on my computer. How do I require a "Log In" every time, unle…

I trying to replace an custom dbase program that basically runs the company from prospecting for customers through customer maintainence and service and installs. I have developed the 16 data bases so far to take care of the customer service side to include the new federal do not call laws. My problem is that I have employees all over the building through out their normal day and jump on the nearest computer and sign in. I need to track everything they do by the employee number. using the "CurrentUser" is great for this but I need a way to change the user in the preferences and appropriate password applied so that current user is the person entering or editing and not the…

Greetings I wanted to know if there is anyway to close a reccord, not to permit any more inserting data or modifing it, after a precise field is commited. Any one done this before? Any idea? Thank you, Toni

I have just converted a FM5.5 file to FM7. A login box asks for my account and password. The account is pre-populated upon opening with the name of my PC. I enter my PW and I am told that the Account and Password May Not Be Used to Access This File. I have tried using 'Admin' as the account, and have also tried both account names using 'Admin' as the PW. But I know what my PW is - it just won't accept it. Does anyone know a way to enter this file using the dratted PW I KNOW belongs to it? Thanks Kurt

Is there a way to re-login as guest without restarting your database file? It's not a huge problem - it just means you need to create an equivalent real account... just seems kinda senseless.

Hi all, I'm trying to write a script that will automatically change the privilege set for the user on the fly, depending on the user type assigned. Does anyone know filemaker has any option to change the privilege for certain user? The only way I found so far is to make the script Delete the Account, and then Add the account again with new privilege set. The problem with this approach is that account's password will be reset. Thanks, H.P.

I have 15 salesmen that access the FileMakerPro 6 database from all over (they use their office computer as well as their own home computer-which limits my use of Auto Enter Creator Name). I have them in a Record_created_by field that has a drop down list of their names(value list). I want them to only be able to access the records that they create. I have tried various variations of limited password protection but everytime after creating a record --they can't see it. I tried limiting password...Record_created_by=Status(Current Fieldcontent)--doesn't seem to work. Any help is apprectiated..

FM help shows nothing. I have established Accounts and Passwords but when they log in, it inserts a default name (old name taken from computer somewhere?). Users don't want to keep having to put this in each time. They want it to remember what that computer used last time it logged into FM. Is this possible? It's probably staring me in the face.

It's funny how writing these questions in the forum can make you think of new possibilities. I was agonizing over this one for hours and then I finally figured it out as I was writing the question If you use the Re-Login script step without dialog, and the user's password is expired, the re-login will fail. You can error capture for this but if you run the "Change Password" script step, it will activate for the currently authenticated user. In my case, the dialog wouldn't even show up if the script was set as an open script - go figure - this just added to my frustration in trying to find the root problem! So what you have to do is script a new password thr…

I there a way to "lock" a field once some data have been entered so that only someone with "Admin" privaledges can change it? or so that no one can change it (that would be acceptable too)...

Its been a while since this was visited. I still have problems with opener files. Does anyone have one that is simple and works? My users are not too happy with all the navigation required to open their files on the network. Ivan

I deleted many passwords from a file, leaving one with full access. When I open the file it will only accept one of the deleted name/password sets. What's up? How can I fix this?

FileMaker is locking me out of most of my files right now. I have no idea what's going on. The thing that triggered this is that I tried to get rid of passwords, so I assigned full access privileges to guest and got rid of the admin account I created. Seemed simple. But now FM won't let me log in as guest. I know the old account name and password, but of course they don't work. I don't think there's any accounts left in the file or something. Is there a way to tell FM to log me in as guest? This is incredibly annoying especially because as Murphy predicts, I forgot to do a backup last night. I should mention that on one of the files if I try the old passw…

I would recommend that those interested in FileMaker Pro 7 and FileMaker Server 7 security read the Tech Briefs on the FileMaker, Inc. web site: http://www.filemaker.com/upgrade/techbriefs.html Steven

FM 7.0v2 Dev. on XP Pro. I must be missing something. Say I have a file called "Data". It has one user account with a password that no one else knows. Some evil doer comes along and creates a new file called "Raider". They define a file reference to Data and they can pull out all of its tables, despite the fact that they don't know the password for Data. Isn't there any way from within Data to prevent someone from hacking in with a new Raider file (outside of totally restricting access to the folder at the OS level)? It seems like they should have to have a valid user name and password as defined within Data in order to get to its tables. But this isn't th…

I am trying to find a way to have the password for a database entered automatically based on a persons username. Here is the situation: There is an opening database, we'll call it Login.fp5, where the user logs in. If the user is a valid user it then takes them to Main.fp5 via a script. Main.fp5 has two passwords, Admin and User. When Main.fp5 is opened it prompts for a password. Is there a way to automate this so the user never sees the password dialog? Ideally I would like to pass the password to Main.fp5 via the script that opens it. I'm not sure how to accomplish this if it is even possible. Thanks for you help, Brian

Hello, I use FMP-WEB connector to publish CDML pages on the internet. I also use the FMP websecurity database to secure my databases. If I connect to my database a pop-up window comes up and asked my to login. But I can't logoff if I' am done. The only way (I know) to log off is to close Explorer completely. Is there an log off script?? Greetings Jukkie

Hi, I've setup a few databases ... I have my opening file that opens all the other databases needed. I've set passwords so that when I log in I get admin rights ... when the user logs in, the only get limited use. Is there a way to find out who's logged in from the password they type in when the file opens? I don't really want to have to create an user and passwords database just for login. I've got an If statement on the user in the startup script ... so: If["Status(CurrentUserName)="Me""] ToggleStatusArea(Hide, Lock) Etc ... but if I needed to logon to the database on another user's computer ... this won't work, right? Any ideas?

I am working on our school's database for a Master's course and want to restrict which records each user can see to just their own students. Suggestions on the best way to do this appreciated. Details: There are 8 users of the database. There are 95 records in the DB, each person needs to see about 10. Some records need to be seen by more than one person. I would like to not have to change anything if a new student is added to the database. I don't have a clue what I'm doing but I was thinking maybe a new field with numbers for each user and if that number is present in the field then they can see that record? I have no idea how to do that though. …

I hope someone can help me figure out how to get this to work. I created a solution which is base on 15-20 databases the interact with each other. I set up a lunch database which basically opens up 2 or 3 databses which contain the information necessary to run the login script (users database, etc...). My login script only check to see if the username exist and match what is in the sytem, and based on that it opens the rest of the databases..... the problem is that I haven't figure out how to setup access privilages(editing, viewing, deleting) for the files, with a scrip. I can go to the "sharing" section of fm and set up a group or password and control it from there, but…

I

How can I have a database with no accounts? I want it to be poblic and not require any user to log in. I tied removing all the users but I'm prompted with a dialog telling me I must have at least one Full Access Account? Thanks..

We are encountering a problem with a set of FP 5.5 files. There are several related files...including a "Home" file that has tabs. Each tab opens a different layout within the file. We have set up groups, rights and passwords for each user group. Let's call the layouts: Home, A, B, C, and D. Let's call the users (groups): UserB, UserC, and UserD. The problem is that we have the permissions set up so that all users can view and operate in "Home" and their respective layouts. That is, UserA is supposed to only have access to Home and Layout A. When you go into "Overview" and look at the passwords, rights, etc., you see that UserA is "Denied Access" to Layouts B…

Hello, Hello, i was wondering if someone can give me a hand with this. we have 28 databases right now and i was not here when they were build, i want to build a custom login system for the employees. I have check some solutions like the gateway but i am new to fm that i dont know where to begin when it come to that that solutions. Here is what i want to do. i want to create a solution where i can give each person their login/password to access the databases. The deal is that once they are login, i want the databases that correspond with their L/P to open automatically. I have the divide the everyone into groups: Operation, Adminission, Managers. Some people need…

Alrighty, it's Monday morning and I'm off to a great start!! I was playing around, clicked the "Try Default Password" when opening the file. Well, that default password gives me no rights to the database. How do I get the password prompt so that I can enter the "MASTER" password??? Kate

I am trying to open a database I developed and none of the users/passwords I have for it are working. I've gone through the list of possible passwords systematically (lower case and upper case) and cannot get back into the file. I am sure it is something I (or my client) did. I have called FileMaker and they do not offer a password recovery service for FMPro 7; neither does lostpassword.com. I'm thrilled that FMPro 7 is so secure but dread the idea of recreating 60 hours worth of development work. Does anyone have any ideas/tricks/tools about how to break into a FMPro 7 file? It is truly a legit need. In desperation, Yvonne

Hi there, A guy gave me a hand to develop this tiny solution to avoid the gray page when a staff enters a restricted file. Instead of ending up with the gray page, it displays a message. Nice 'n Cute. Now I want to add a third password that enable the user to enter the file with the same restriction. I've been playing around with for a while without success. Passwords: Admin = 120 Staff = 1 This solution uses a mix of groups, the Welcome script and a global field. Thanks, bk17

I hope someone can help with this one I run my own small business and we use Filemaker to near enough do all our administration work. My problem is that if someone decides to leave my company (I'm not paranoid honest!) they could just copy the files off the computer drive, use the data and/or use the database to set up on their own. If there anything I can do to prevent anyone firstly seeing the files on the computer and then preventing someone copying the data to another computer and then opening he files. Thanks for your help.

Has anyone heard of this problem and is there a solution? We had an accident in our office today and lost all the data in our main database because an inexperienced employee accidentally "replaced" our existing database thinking she was "opening" it. She accidentally chose "New Database" from the File Menu instead of "Open." These two options are right next to each other in the File Menu. Our computer expert says that Filemaker Pro does not have a way to stop a user from creating a new database because it's not seen as a security problem. But that is a weak spot in my opinion. And I'm suffering because I haven't been doing backups and I've lost 3 months worth of…

The database system I'm currently designing (it's in the very early stages) will essentially handle my client's day-to-day business, from tracking customer information to tracking payments to scheduling appointments with customers, etc. The reason I'm posting is that I'd like to get some opinions on how to track user activity and set permissions. I'm considering implementing a very simple login/tracking system that employs a Users file. This file would be opened first and the user would have to "log on" to the system. Once logged in, a global (or set of globals) would contain the current user ID and any other information required. That way, whenever a new record is c…

I've three computers, call them A, B, and C. A&B are notebooks with fm6. C is a desktop, that I want to use as a server of sorts, that's where the FM Files will reside. A&C run XP B runs 2000 if that's an issue On A, I've created an application. I copied the files to C, and opened the files on A (the computer they were originally created on) all is well. When I open the files on B, (whether they are opened on a or not) I have problems. 1. I have to give user on B full access or I get "No Access" 2. User on B, now that they have full access has to let FM know where every linked file is. Everytime they go to a page that needs a related file …

Hello, In an application that uses 12 FM5pro databases, I'm trying to give someone read-only access, but I get a "no access" message in my layout-screen instead of the records I wanted to show. All the files are multi-user, and I created for all of them a new password as following : browse records = checked edit records = unchecked delete records = unchecked create records = unchecked print records = checked export records = checked override data entry warnings = checked design layouts = unchecked edit scripts = unchecked define value lists = unchecked change password = unchecked available menu commands: none This looks fine t…

I have a question regarding password protection. I have searched the forums and not found an explanation to what I am trying to do. I apologize if this has been asked before. I have a Filemaker setup where myself and one other person have full access to the Filemaker database. We have assigned 10 or 12 passwords with restricted privileges for other people to use the system to browse and edit only certain documents. Due to the nature of our facility we would like to leave Filemaker open and running on one computer 24 hours a day (to remain host) but are uncertain of how to accomplish this. One idea is to set up FM so that when it becomes idle it remains open …

Hello, I need an example formula for controling EDIT ACCESS to records in the Menu > File > Access Priviledges - EDIT RECORDS(Limited). Thanks in advance. hpuna

I have a 24 file solution in FM5 converting to FM7 for a small office. I am posting this to see if there is a better way of handling security. There are two levels of users, me the developer and the end user office staff. I have full access but the staff has access only to non-dev functions all through buttons. Status area is hidden and locked. The menu bar is disabled as much as FM allows so that that scritps controll all acess. All fields are set to be entered or not on differrent layouts. There are separate layouts for find, edit, enter, view, with fields and buttons that appropriately guide and limit access to data. There is a file (STAFF) that lists a users …

Hello everyone. This is my first post. My db has a privelege set that allows the password to view records that have the field named [Viewable = "yes"]. My goal is to allow the admin to select the checkbox for Viewable only for records they want viewable. It's working perfectly except: There are a couple of records that are not viewable no matter the Viewable field is checked or not. Any thoughts? Thanks in advance for any help.

Not sure what is going on here. I have a file where I cant delete any records. I have full access and the options to delete are available. I do the delete all records and nothing happens. I have also created a clone and that doesn delete either. ideas appreciated thanks

Hello I would like to lock out the possibility of others changing the number of records I have in a table is that easily possible somehow. Thanks

Our system will potentially have millions of users, each one registering and running a script that creats an individual user account (with associated password and privilege set). We understand that the server will only support 250 users simultaniously, but there will be a lot more user accounts than that. We were just wondering how manu user accounts FileMaker 7 can handle?

Hi, I have a contact management database, I want to set permission where if "sales person-1" logged-in as "sales1" he can only view contacts and all invoice history created by himself which is "sales1", not contacts created by "sales2" or any other users. In another word, if the entire database has 100 entries, and "sales person-1" created only 10 entries, he can only view his 10, not the other 90 entries. This way, I'd like to have our 3 different sales people only look at their own customers, order history, and invoice amount. One would not see the other two's customers and how much they've sold. Thanks

Hi all, this is my first post on this forum. I am working on a time-billing solution that is designed to have two levels of privileges, an Admin level and a User level. I would like to use Filemaker's built-in security scheme, but the solution needs to allow Admin to create User accounts. However, I don't want the Admin level to have [Full Access] privileges. It is my understanding that only [Full Access] accounts can create additional accounts. If there is a way around this rule, I would appreciate any info. Otherwise, I guess I'm going to have to generate my own password fields, password scripts, and accounts to make this happen. Thanks, HampMac

Hello, I have several BD's related including a main menu. What I want to do is: set in the main menu passwords for users and admin, and when opening the related BD's, the main password setup passes to them, without logging the password again. Is this possible? If is, how can I do this? Thanks in advance. kind regards. FileMaker Version: Dev 6 Platform: Mac OS X Jaguar

Heres a cut down version of our secure logon system. I've modified one of Filemaker 5.x's generic templates to work with the solution. This is a rudamentary implementation but gives you an idea of how it works. Username: steve Password: secret or Username: guest Password: guest Oh... you will need Troi's Dialog Plugin http://www.troi.com for the solution to work. The use of this plugin can be removed but I was too lazy to do it for this demonstration. Cheers! Version: v7.x Platform: Windows XP signon.zip

This is a neat little VBScript that pulls the user's logon username, as well as computer number, and saves it to a text file on the hard drive. (Note: Windows only) The script can be executed through a Send Message step when opening the database, and the data can be imported to not only assist in custom file permissions (field-level, if you so desire) but also to create logs of who accessed your database system. So you don't even need a password-based login system, this script is basically flawless. I'd be happy to provide an example database if needed. Note: When using calling this script from Filemaker, and importing data from the text file, it takes a few seconds…

The menu selection "Accounts & Privileges" are dimmed in my File menu. I have the password and username, but are not able to write it in anywhere and therefore not able to access several areas like scripts and layouts in the file. What is wrong and how do i fix it? -truls FileMaker Version: 7 Platform: Mac OS X Panther

Please can you help. I have a FileMaker database setup by a graduate that was working for us over the last few months. She has now left and has password protected the database. First question: How do you specify the

Is there a way to restrict the visibility of certain layouts? I would like to control this at the password protection level but I don't particularly want the statement "RESTRICTED" to be readily apparent. (Less politics). Can this be done without deleting the layout tab from view? Thanks, Jarvis

Parameters: I am designing two related database for employee time tracking. I have one database (call it Time) for creating a daily time sheet record for each employee. A second related database for each client billing item, (call it Time Line Items). After a daily time sheet is created in Time, billable time line items are entered in the same Time database/layout via a portal with a relationship established to Time Line Items. The portal works and line items are created properly. I have establish record level security by assigning a group name (the employees name) along with a password exclusive to that group for each employee, then created a field LoginVeri…

I have set up a users file to compliment my dbs so that I can control access and have the user's name in a global field for electronic signatures. I have a script that date/time stamps and adds the user's name per his/her login. Works great, however, our QA dept. wants the script to also prompt the user to re-enter his/her password for added security (in case s/he walks away from the desk without logging out, I guess). My files are served and my users are on thin clients so "Current User" doesn't work. Any suggestions? Thanks. Version: v5.x Platform: Windows XP

Is this possible? I want users to only be able to view records that they created. I would like to have them enter a password and then have a script that would run automatically to find records that they have created only. Is this possible? Ron FileMaker Version: 5 Platform: Mac OS 9

Thanks to Bob for cracking version one which contained cleartext passwords. Here's version two for those of you stuck using FM 3,4 and 5. This is a little more secure than the previous version. - i had uploaded version 2 but i forgot to set the usernames and passwords, so here is version 2.1 all fixed. Username: steve Passwod: secret -- full access Username: guest Password guest -- limited access Bob, I'll pay you $50 if you can give me the third records username and password Would you mind telling me how you managed to establish a relationship to the locked file? I am gobsmacked as to how you did that. You da' guru Thanks ag…

I am currently developing a FileMaker Documentation database. I have been searching for a simple login script on the internet but I can't find anything. I want 1 FileMaker File with all users and password. After you logon, there will be acces to the documentation database. FileMaker Version: 6 Platform: Windows XP

When I try open a Filemaker file of mine... I get the following message: "Is write protected or in use - you will not be able to make changes." but it doesn't even come up. Please help, I really hope my data is not lost. FileMaker Version: 5 Platform: Windows XP

I have been unable to open one of my files and therefore performed a file recovery. However when I try to open the 'recovered' file it says the "access privileges are damaged or corrupt". I have looked at the support section on Filemaker's web site but had no luck. Also I tried to open the backup copy of the file which was performed on Friday evening but that is corrupt. Can anyone please advise as I need to get this file up and running asap? Version: v6.x Platform: Mac OS X Jaguar

I am working on a system that has some very strict password change requirements. FM 7 is a great improvement over the previous versions, but I have a problem. When "Must be changed every __ days" is selected, it appears a user can re-use a recently used password. Is there any solution to this (short of using an external password system)?

Hey! Here comes a rather easy question but my knowledge is limited! I've one file which contains a number of users whith there personal passwords. How do I create the script that will ask them for there username and password, verifie that the data is correct and then make the users log in with limited acces preventing them to go to certain layouts and delete certain records.