Security Concepts

This is a F***ing nightmare. I am locked out of all my files since I no longer remember the password. I thought I turned off all password request but it appears I was wrong. Is there no way to change this at this point. How do I turn off password protection I do not publish to the web and I am a one person office.

I have never locked my database, I just went to open it and it won't open without a password - Help ASAP Thanks

Hello, Does anyone know specific differences between these two options? I've switched back and forth a number of times and I don't see any real differences. Also, I have FM Pro 7. My three options for "available menu commands" are: all, editing only, and minimum. Is the "none" option that I've heard about part of FM Pro 7 Developer? Greg

Hi... two of my users have reported in the last few days that some mysterious keystroke (they don't remember what they pushed) has cleared the ENTIRE record that they are working on. One person says that all of the content just disappeared, but the record still remained present. The other person says that the record was entirely deleted but there was no popup window to warn them. I can't recreate either of these situations! arg... Does anyone out there have any ideas how either of these scenarios might occur? Thank you for your kind help! Gradiva P.S.. while I'm at it, does anyone know of a nice list of FM6, MacOS keyboard commands that I …

Hi, I was wondering if I deny a user access to a pricing table, will lookups still work? I had a user enter a unit code and the price and description fields did not populate. I am not sure if this is due to the access limitations or not. Thanks

Is it possible to give a user a "Change Password Only" Privilege without giving them "full access"? We have a Help Desk group that a User calls when they forget their password and the Help Desk resets their passwords for all of our other types of software and accounts. Also, can a script be written when the Help Desk changes the password for it to change the password in all the related files. Due to lack of time, we are not converting all of our 7.0 to only one file with tables. We will still have files that have 7 or more related files. Any help is greatly appreciated! Adele

I am trying to figure out how to implement a multi user system. As it stands, the sysetm works for a single user, but i want to be able to keep track of user id's for changes made and records added. What is the best way to implement such a system? I read the book, about user accounts and privileges, but I am not sure how to keep an active user Id that can be affixed to new records and used to generate daily reports. I haven't experimented with filemaker's user account managemnt too much, so I could be saying nonsense. However, it looks like filemaker only makes available the user account name? I think the best course of action is to make a table to hold all of t…

I imagine this has been discussed here but I looked through the forums and didn

I have a question: can I get FileMaker Pro 7 to just show a login user's data, versus seeing other records as well? For example, if a user logs in, I want that person to be able to just access his or her records and not anyone elses information. Thanks, mvang04

In "File Options" I set my FP7 file to open in a limited account especially made up for Instant Web Publishing. Now when reopening the file FP7 starts with an error message "Filemaker cannot share files over the Web because Instant Web Publishing could not be started". After hitting "OK" the file opens by itself, in the LIMITED PRIVILEGE account, without asking for account name and password. Thus the File/Define options are greyed out, no way to reach the Full Access account and the necessary "File Options". Fortunately I made a back-up right before, but I still would like to know how to solve the problem, how to get back to Full Access in this file. Any ideas are…

Is there any way to prevent the ability for users to resize filemaker windows in my solution? On mac mainly, but on windows as well. I have the secure fm plugin from new millennium which lets me disable the file minimise/maximise and close buttons. Is there a way to stop the resizing? Either with/without a plugin? Basically so that the solution I'm working on at the moment can only be either minimised or maximised. It annoys me when I see people who've resized the window to a tiny quarter so that they can't see the whole layout. Any ideas? Thanks Ben

I have a set of 23 .fp5 files for which the administrator password is lost. This was setup by a 3rd party who did not give us the admin password. We just realized it now, when we wanted to make a change on a layout and a field definition. We cnnot get it from them, and I have only found Password cracking programs for 4.0 and below. Are there programs for 5/6? Also, does anyone know the cost of having Filemaker open the files, and if you have done this, do they just remove the passwords, or tell you what they are (so we could do 1 versus 23 files!)? Any help would be appreciated. Thx! -dana

Is there a way to change your default password? Whis is to say your password defaults to what you used last time, and only on your computer?

Any one know how to hide the menu bar when the file open and only show when admin want to? Any hints would be help. Thanks in advance

I'm having a hard time articulating what I'm looking for, which is making it really difficult to search for a solution on the forums. I've got a database with a Personnel table, which holds info about each staff member, including "Employee Code" and "Team". In the same db, I have a "Time Record" table where Employee Code is an auto-entered field equal to AccountName. I have a "Team" field in the Time Record table which is a lookup from the Personnel table based on the Employee Code. For base level employees, I have privileges set up so that they can only view and edit their own records [with the calculation: Employee code = Get ( AccountName )] I'm setting …

I have a Log Database that tracks events in a computer room. I am trying to share it with others. Here's my story... Database name: Log File Accounts: king (full access) Superuser (not full but more then just data entry) Basic (data entry only) there are 4 secondary files linked to the Log database. They are: building staff inventory emergency There are two accounts on each of those four files king (full access) simple (data entry only) We have set the File Options to four secondary files to Open with account "simple" using the correct password. What should happen Double click on Log Asks for name and passw…

I have a two file solution that users are required to change passwords every month. Yesterday two users were required to change passwords and those two users experienced problems soon after. One portal that displayed related files by a date match no longer worked, nothing seen in the portal. Examination revealed that the fields that the match occurred were correctly filled and data should have been shown. From another account, the portal was showing correct data. Changing the problem account to full privileges made the portal fill with correct data, changing back to limited priveledges, portal now full with correct data. The other problem account still was not showi…

I have an interesting problem. In the implementation of an external function (plugin) I need the access privileges to be reevaluated on each field change within a layout. Specifically, I am using EventScript for this task. Here's the gotcha, in the example file provided by the developer, FileMaker reevaluates the record Level access priveleges after each field change. In this way, the attached script runs every time a field is entered. It works, I totally demolished the example file to prove that my functions work in it also, and that's all well and good. Except! In my version of FMP7 (current version) I attempted to duplicate the action in two different files …

All of a sudden nobody can modify any records on our database which is held on the server. Over the weekend I downloaded the file to my desktop and did some alterations. I then uploaded the file back onto the server. Since then, nobody but me has been able to modify anything in the file from the server. We've never been able to have the file open by more than one person anyway! I can reopen the file on my computer and modify anything as an administrator and as anybody else. However, even I can't open the file on the server or any other computer as administrator. I'm sure it must be something simple but darned if I can find it! Incidentally, I've posted thi…

I have developed my system to run in kiosk mode to strictly control what the user can or cannot do. I have just realise that by clicking the right hand mouse key they have access to various options ( one of which is delete record which scared the pants off me). Does anyone know of a way of controlling the mouse button functions within FMP whilst leaving the right hand button functioning as normal outside of FMP Thanks in advance Phil FMP5 XP

Hello I have two databases that I want to remove the passwords from. I set them up with two levels of access: one for administrators who could change stuff as they pleased and one for guests who could only browse and find stuff. Little did I realise these levels of access already existed! Anyway, I no longer need to password protect the files - it causes more hassle than it's worth to be honest. So I went into Accounts and deleted the two accounts I'd created. However, people are still being asked to log on. I can't delete the accounts that are standard as I get the message that there has to be at least one account. So how do I stop it asking people to log on? …

Is it possible to create an ID/PW for each FileMaker user? We currently utilize the password logic in FMP, but were hit on an internal audit for poor security since we did not have an ID/PW process. Is this possible with FileMaker Pro 5.5?

Hi all, I'm relatively new to FMP7 and building my first solution. I'm wondering if there's a way to lock a field (from edit) based on some condition. I have a field in my main table, "grade", that should be locked based on a date range of two global fields in my user interface table. I have the global fields "grade_begin_dt" and "grade_end_dt" set to the date range when the field "grade" should be open. If the current date is outside of that range, I want to lock the "grade" field and prevent any edits. Any thoughts appreciated! -Heather

I'm working on a fairly big project with lots of databases but there is one file I'm having trouble with. This file was created and used in FM5, I think. I have FM7 and this file was converted successfully. In fact all of the other files are working fine. When I open the problem file the the following menus are greyed out: File > Define > Database File > Define > File References File > Define > Accounts & Privileges Also, when I attempt to access the Open/Close and Text tabs in the menu File > File Options I get the following: "Account privileges do not allow you to perform this action" No where does it ask me for a password. Ho…

We are using FileMaker Server 7 to serve a database. FileMaker Pro 7 clients are connecting to the database using an account that uses the default [Data Entry Only] privilege set. Clients have enabled "Save layout changes automatically (do not ask) in Preferences > Layout. When clients navigate manually between View as Form, View as List, and View as Table in Browse mode, they are presented with a "Do you wish to save this change with the layout? (Yes/No)" dialog--even when no changes have been made to data (let alone the layout). When clients with default [Data Entry Only] privilege set use a script whose only step is View As [Cycle] to navigate between View…

I purchased a package from www.databasepros.com and was given a master password which I cannot use. How do I configure FileMaker to use a master password? Does this password apply to all files on the system, or just to the ones that I downloaded? The account name when I attempt to log onto the fresh copy of the files shows as my name ... is this picked up from the operating system? I've looked in the User Manual, but it does not appear to discuss administrative functions. Is there a separate manual for that?

Hello all, it looks like there is no Option to "Limit" Create Permissions other than disallowing or allowing. I have many many occasions where i want a User to for example add Items to an Order Items File via a Portal in the Order File, but dissallow Edit and Create Access when he printed it. I hope i am just blind and cant find that Option, but Access Privileges only seem to allow Yes or No as a Choice for Create, while Edit f.e has Yes, No and Limited. I mean; I understand that the Record Access Priviliges are based on the Record, but still. If a certain Record is locked for editing, one should not be allowed to enter new Data in a Portal on that Record / Layout. …

Hello all; I have a file that I want to block the Duplicating option on the pull down menu, but they need to be able to alter the record, so duplicating is the only part I need locked out. I have the other settings I need in the password setup section for each user. If you need more info, just ask, or a copy of the file, anything to help. Thanks. Donnie

Hi, I have a solution where certain accounts don't have access to certain records. Let's say account "A" has access to all records and account "B" has access to only half. I hid the status area and set up a login script that did a find based on access so that account "B" wouldn't see a bunch of records with "no access" on the screen. All the buttons and navigation tools would keep these records from being viewed. The problem is that they can still click on "records" and "show all" which negates the whole process. There must be an easier way to do this so account "B" would only see the records they have access to. Is it a relational thing? thanks in advance for a…

I have a DB that's pretty simple, really. Standard User can see and modify only the records they created. Supervisors should be able to edit a subgroup of users' records, all said subrecords have the Supervisor's login name already in a text field in the record. The Standard User is doing fine. The Supervisor can view and edit the correct records. BUT - the supervisor can only get to those records by manually browsing and clicking through records to find the correct one. When the supervisor does a "Find" on any field, they get "No Records match this request." Obviously this is a false error message, the records exist. So why can't my Supervisor's search fo…

I have just bought FM 7. I like it. I have a relational database, that I'd like to access from a single table (called "Main") that contains only a layout. The layout has buttons to allow access to the relevant data tables (such as "Consumables", "Vendors", etc.). I want to set-up account privelages that can be used for all tables. One account will allow full access so that I can tweak things, the second is for a user who will not be able to delete records or change layouts and scripts, etc. However, I want either user to login once to the "Main" table, then when he/she selects a specific datatable, I'd like the user to be able to access that table without ha…

Is there a way to make a database to use another database for user names and passwords?? For example have a master database that contains User Name, Password, Priviledge Set, and link that to all other databases?

Hello, can somebody give me a hint how to lock data, that have been printed or expired? I am using a calendar in my company and my employees should not be able to change already past days or created and printed invoices. It looks like I cannot do this with a script, is there any other possibility to move this data to a admin section where it cannot be reached by others? thanx Sunemi

Hi folks - Here's a puzzling one for the experts: I have implemented a multi-table solution under FMP7.0.3win for our small company. The thing that is a bit special about it is that it can be synchronized via a central file residing on our office desktop, so my colleague and I (and future collaborators) can use the DB offline while on the road and then sync it when coming back to the office. I got everything to work just fine except for one point: When the synchronization is done from my laptop, it works fine regardeless of the active account (full-access or custom-defined priviliges). When the sync is done from my colleague's laptop, it also works fine under …

Hello, I am running Filemaker 7 Server on Windows 2000 Server, and client computers are all running FMP 7 on Win XP. I want to use the external authentication by the Windows 2000 Server, but I don't know much about the LDAP, Active Diretory... so I don't know where to begin. Can anyone show me the requirements and steps for how to setup the external authentication for filemaker? Some client computers are running Win XP home edition. Does it matter to use external authentication for filemaker? Many thanks in advance! Damon

Hello all, somebody has asked a smiliar Question before but i guess he was misunderstood so it was left unanswered. I am managing all my Accounts via Scripts in my Employee File. I have multiple files and i dont want to setup Accounts in every File. Can i make Filemaker use the Accounts in my Accounts Table from my Employee File or is this not possible? regards, Overrider

Does anyone know if it is possible to simpy not display anything when a client does not have access to a file instead of the <no access>? I would like the database to simply skip any that they do not have access to and go to the next accesible record. The truth is I am hoping to accomplish this on my XML/XSLT version of the website but I figured I would begin with the actual database and build from there. Thanks Brad

I have a inventory database used by 15 different clients. Each logs in with there given login and pass. In my privleages I set a calculation to allow them to only see the data that is associated with them. This is done by setting the records access to limited. I use the calculation: (Records can be viewed when Client="Ultra") (ultra being one of my clients names) Every record has been tagged with a client name in order to make this work. This was the simplest way i could make this work and seems easy to maintain. My only conern is that this slows the database down as this calculation must be preformed on every lookup. Does anyone have any suggestions on ho…

I discovered this behaviour under XP, did not chack against MacOS yet: I log in as Guest, with the standard Read-Only privilege (confirmed by a calc field that displays account / access). FM7 (Dev 7.0v3) prevents me from changing anything... EXCEPT that I can change any *global* field without problems. And the changes are not just visible in the layout, they really go to the database. Did I miss something? Or did FM? Can anyone confirm? (puzzled)

I have been using a template created in 1992 by a company that is no longer in existence. Each FMP upgrade has been a smooth transition until 7. A window would open asking for the password, which I entered and everything was great. Now it asks for the Account Name and Password. The same password doesn't work with my name...removing my name and just putting in the password doesn't work. I need to change a layout and export, so going in as a Guest doesn't work. Does anyone have any ideas how I get to my file? I'm feeling a tad desperate!

Post deleted by splante

Hi Ok, so I've just started with FMD 7 and I'm still a complete novice - and from a filemaker community point-of-view, I'm totally for sharing stuff, ideas and demos... but I spent the last 3 years building this database which I have finally managed to start selling - the market is limited to just 2678 potential customers ( in reality I will sell to just 5-10% of that market) - that is every school in little old NZ - the product I sell retails for just $120 USD... and once a school has bought it the licence use is unlimited - stick it on any and every computer in your school. My issue is that school's in NZ are notorious for copying software - you know, no…

HIPAA requires password change every 30 days. I have two files with password protection, second one opens hidden. At password change users are requred to enter account name/pword for fist file, change pword. Then enter account name/old pword, then change pword again. This is workable but annoying and sometimes users get confused with the second login requiring the old pword. Previously I had the pword inside a database but not as secure so using FM7's. Any suggestions or just continue with above?

I

Is it possible to create a form that allows the user to enter a password, which will then be used as the password for the next page, rather than loading the page then entering the password?

For some reason, and a very scary time, FMP7 wanted a password from me that I never set. I am the only on using the computer and I was doing non secure work. One day it asks for user ID and password. Luckly after several tries I did Admin as my username and no password. I want to remove all requests of security when I start this file. Suggestions please

I want to create a database that will allow a user to input data into every field accept two. Is there a way to protect just those fields with a log in and a password box? If so, how? We are currently using FMP 5 but can upgrade to newer version if needed. We have just started using the product and I am sure just touching the tip of the iceberg. Thanks for the help in advance. joe

Is there a way to set Privileges so that a guest account can delete 1 record (record being browsed) but not be able to delete ALL records. I hope this can be done. I want them to be able to delete a record if a type-o is made, but not delete every record. Thanks for your help.

I have installed FM7 on my other Windows 2000 machine. Everything seems to be working fine. I have copied to CD a FM db from my Windows xp machine and when I open it on the 2000 it will not let me do a thing with it even though I did assign an account to it. Keeps saying: "This action cannot be performed because this file is not modifiable." Any ideas?? Is there a trick to saving on CD in order to open on another machine??

FMP 7

Hello, We have an old v5 database that is password protected. Attempted to covert it to v7 & it is asking for account name and password. Since v5 never asked for account name we are stuck. Person who created the database with master password is gone. Any suggestions on how we can successfully convert/access? Many thanks,

I have a database set up with external authentication through LDAP, v7.3, MacOSx. Everyone can log in fine but when all users (except the administrator) try to do anything (create, etc.) they get the following error message: "Your Access priviliges do not allow you to complete this action." Their privilege set allows them full access and the order of authentication for groups is fine. Does anyone have any idea what I am missing out on? Is there some special permission that I need to grant for the groups?

Post deleted by JFul27

I'm not sure I'm understanding the logic of the allow printing switch and available menu commands in the edit privelege set window. I want to be able to print documents, but maintain limited access to other menu commands. I have a script pausing in preview mode to allow printing. I've tried running this script with full access priveleges and the minimum available menu commands is still involked. The privelege set has allow printing checked and minimum for menu commands. The only way I can get printing to show up is to change available menu commands to all. Is there a way via the privelege set to allow printing, I can do it via script and dialog, but I do…

Is it possible to for a user to change his log in and password in the developer edition?? Is there a example script?? I consider to make a settings layout where the user changes his user preferences, delete edit change... Any help? TMAS

I'm designing my own log in page. Is there anyway to convert the text in the password field to bullets and still capture the actual password entered? I don't really like the idea of changing the type to the same bg color idea! Thanks.

Hi everybody, Perhaps there is some help for two questions? 1. Is that a filemaker-bug or simply a lack of competence of my person? The "Get (Record Permissions)"-function (I hope I have translated its name properly from German) returns always "2" - even if a user doesn't have a single permission. 2. Is there a possibility to get information about the delete-record-permission? As I found in the documentation one can only get information about display-, and edit-permission by the function mentioned above. Would be great if someone has got any ideas for me... Best regards, Bernhard

Looking for a method to make a fm 7 database run off a cd, basically it should only run off the cd. any idea how i could do this. opinions are welcome [email protected]

Hello, I was wondering if there is a way to do this. Basically i want to give someone the option to A Record but not the option to Delete All the Records. if the person is the current, I want them to be able to delete only that one. Thanks victor

Hi, I am trying to set up a set of privileges and having problems. I have a database (FM 7; Mac OS X) that is used to prepare an order, which is then emailed to our finance dept. I have just two users - admin and someone else. I would like to give them permission to generate an order, and modify it to their hearts content until it has been emailed. This is all fine. However, after the email has been sent I would like them to be able to alter just two fields on the record, but not the rest of the record. This is where I have the problem. I have been able to set it up so that they can modify the record only when it meets one of the following criteria: 1…

I have about 100 db's and just upgraded to FM server 7 and pro 7. I want all of the users to only have data entry access, and they can all use the same password. But I also use the username in filemaker to determine who entered test in some fields so the usernames need to be unique. Is there any way I can set up an account that will accept any username as long as the password entered it correct? The prolem is I have some turnover in staff and if I have to modify the security settings on each file every time I have a new person start it's going to take me forever. I also have Server 7 running on a windows Domain. Can I use that to simplify the security? Than…

I am constructing a small workgroup solution that is hosted on a standalone machine running FMP Server 7, and besides regular "users", I am trying to provide an "administrator" account, such that a particular user in the workgroup can control a certain number of database wide functions (resetting account passwords, close out some tables, etc) without having to use the Server Admin program or access the host machine. The problem I am having pertains to "globals". I am using globals to track a certain number of database wide varables: some key titles, a "last data release date" etc. I provided the administrator with a way to change these globals, then discovered …

Unable to share a FMP7 database. How can I fix this?

I working with a database with several users and one file. Security for the file consists of a layout that starts out by having users auto loging in with a guest account and automatically switching to a layout "Startup". From here users can click on one of five buttons. All five buttons run a login script (for username/password entry) that takes them to different layouts. Once they are logged in, I want them to be able to select a logout button at the bottom. The button should run a script to take the user back to the "Startup" layout and log them out automatically. Once they click on one of the five buttons again they would HAVE TO enter a password/username to go a…

I have a created a web form which authenticates a user by their ID and password using the -Find action, but I would like to also give user's the ability to change their password ie enter your old password and then enter new password. Does anyone have any ideas? Thanks.

I have built scripts into my database that allows users to create new records by clicking a button. This script actually only duplicates the previous record, as there are certain "hidden" fields that need to be on each record, a does a variety of other functions. Basically, the user thinks they are creating a new record rather than running a script. Here's my question: Is there any way to prevent the user from using keyboard and menu shortcuts, forcing them only to use the scripted buttons. I have tried limiting access but it appears that once the "create" record option is deselected, the duplicate function does not work in my script either. Any thoughts or sug…

Has anyone else had this problem? Problem: - Record Access to Limited - Windows XP - FMPro 7v3: On a Detail Layout where End-User should not be able to see Field data on all Records, some fields have <No Access> and other happily show the data that they should not be displaying - Macintosh OSX 10.3.7 - FMPro 7v3: Records data was properly displayed on all Fields per the Access Rights set-up Resolution: - In the layout mode, I copied the Fields that were working correctly, showing <No Access> where they were suppose to and pasted them back onto the layout. - I re-defining the copied fields to the Fields that were showing data that they…

Hi Can someone please tell me how secure Filemaker 6 and FM Server 5.5 are? If I have set different levels of passwords in a database file (admin and general users), is there anyway that someone could get round the admin password to change startup Applescripts in the database (assuming only the admin user has access to these) What I want to do is lock down a database as tightly as possible so users on the network can't get into Scriptmaker or change the start up script. I don't want to bind the databases in Developer as if is networked and runs the web companion. Does anyon e know if there are any backdoors to getting into them? I'm not worried about the web security …

I'm quite sure this problem has arrisen many times before on the forums, but i cant seem to find anything when i search for it. My problem is ive created a database of around 10 related files, all accessible through one main Menu File called "Menu.fp6" (Funnily enough!). I have create access privileges to this file and want similar (although sometimes different) privileges in the related files. How do i ensure that the password is copied across to the other files. I dont want the user to have to type in their password every time they enter each file, especially as opening any one file causes the related files to be opened and this would force the user to input their …

Hi, I have a database that will be used by two different properties at the same time. We like to keep the information separated by property. I have it set up so that when you use your id number it automatically looks up your property and places that code into the property field. it works via lookup to an employee database. It works fine with my ADMIN account, but I can't get it to work with anyone else's account, it always comes up blank. I have the privleges set up so that everyone should have access to that Employee database table so I can't figure out why it's not working like the ADMIN account? Is there something I am not understanding? Does it matter if i…

I successfully converted all my FM files from v.6 to v7 some time ago. Only 2 of them had password protection. Both were simple, flat databases. Now, when I need to use one of them, I can't open it - with the message that the password is incorrect. The other still opens fine and works well. It used the same password! Anyone have any ideas on what's going on - or better yet, how to open my file?

We have had a password go bad; the passwords work for other users, but for some reason, we cannot get one password to work. It hasn't been changed by the end user, Has anyone ever seen anything like this? Could this be somewhere in a script (you can tell this isn't my database.) Any direction would be appreciated.

I've got a solution that I am working on the security issues with. One thing that I did notice is that within my solution field level access works as I expect it to be but then I tried creating a test file not part of the solution files and creating a table occurance in the test file of one of the solution tables and I was able to see all the data, I know this was covered in DevCon but i just can't remember how it was done to prevent users from seeing the data in the event that they created a table occurance of one of my tables in a dummy file. Any tips on how to prevent this would be appreciated... Thanks.

Hi, I want to put a portal on my home/initial screen that shows the users currently logged into the system. I made a simple database called UsersLoggedIn with 1 field, Username, and set it to autoenter creation account name. I then set the login script to create a new record and the closedown script to search for the record and delete it when the user logs out. The problem I'm having is what happens if the database for whatever reason crashes? Besides making a button to reset the logged in users would there be any way to detect that the file is being opened with no other users on it? Also does Filemaker Pro itself keep a record of the accounts currently accessing…

I am doing a project in university and one of the enhancements is online access. This would be fine except me and my partner don't know where to even begin for this. If anybody could help before 12/02/04 we would you owe you!! Thanks for helping out two university students. Leah

I have developed my screens using FileMaker Pro 5.5 and am running FileMaker Server 5 on a Windows 2000 server. When I run any of my screens from the server via the Hosts button anything to do with record manipulation is ghosted, not available. When I run these same screens from my development computer all is well. I have no passwords set. I have tried adding passwords, such as restricting design layouts and scripting which works. But still no access to record manipulation. I have now removed those test passwords and have priviledges set to Access Entire File. I have given the users on the network Administrator access, still no good. I also verified that all files were se…

Hi, I'm dealing with a strange file. It's a normal FP5 db, with some user and some different privileges. I've guessed the admin password (the pwd was admin :, but I cannot even access the ScriptMaker, or view/modify the fields. I know that is possible to "close" this features by FileMaker Developer, creating an "execute-only" files. It is possible to "open" this file in the right way, or see the fields to understand a calculation? I need this 'cause the developer of this file is dead, and is impossible for us to recreate all the DB.

Ok, this is driving me nuts. I have finnally figured out the "access privledges" thing but when the user logs in, he sees all the other records with the <<No Access>> label on the fields. How do I make it so the user only sees his records and can't "roledex" through the others. I know I could hide the left pane but then The script has to be written so it goes to only the records the user can view. I've tried defining a Global Variable with the Get (GetAccount) and then performing a find in my script but my Find script doesn't let me put a variable in. I can only put in literals. I must be missing something here. Thanks

Hi all, I am very confused. I have a simple database that I created in Developer 5.5. When I open the database in FM7, it asks if it is OK to update the DB for FM7. I say OK, then I am greeted with a password dialog to get into my database. I can choose Guest which allows me to enter and edit records, but I want to edit the database itself. Anyway, I have never turned on any of the security measures, never played with access or anything else. My guess is there is some strange bug in the upgrading the file to FM7. Any thoughts? I have tried a few times (re-opening the OLD FM5.5 file) in FM7 and it does the same thing every time. This does not occur on…

I'm seeing strange behaviour with my privilege sets. I have multiple files with the same group of privilege sets. When a file opens it runs a re-login script and looks to the login file for an account name and password (which is entered by the user when they login). The thing is that the privileges seem to be in place, but i have a message box showing Get (PrivilegeSetName) and no matter what set i use, some of the files always say [Full Access]. I've tried the following - checked the offending files are getting the right account name and password from login. They are. - re-entered the privileges. Typed very carefully - manually entered the account typ…

I have a user who has a FileMaker 5 database. This file only has one password and that password does not have full access. I used "FileMaker Key" and confirmed there is not a password that has full access. So, my question is how do I gain full access to this database?

Using the re-login step seems not to return the correct error messages. When I test the below script if I cancel the script it sets last error to 1 and the script works as expected, however if I type a non valid account name, without password the last error is set to 0. I would have expected an error 213, which would have looped back to the re-login till the max login attempts were reached or a successful login was completed. As I see it with error capture on relogin does not set the proper error number. Am I not understanding something here or is the another bug? Script Example: Adjust Window [ Hide ] Set Error Capture [ On ] Loop Re-Login [ ]…

I've got a solution that will be personalized to specific individuals before being burned to CD. To allow the personalization, I have some admin-only layouts and scripts that are used to enter the customized information before the CD is burned. To make it impossible for the end-user to get into this stuff, I'm considering using the "Remove Admin Access" feature of Developer, which is something I have not ever used before. The description just says it permanently removes admin access and hides calculations, but doesn't go into any detail on what this means. What does this option really do? Does it simply disable the Admin user from interactive login, or does it…

We want to create some runtime solution to our clients which containing critical information. They need to modify, create and delete the records but we do not want them to export the records. We have disabled the export permission in their account. However, if they create a FP7 database and use the import function. All the data are extracted within mins. How can we prevent that? All the data are very sensitive and we do not want them to export. Any solution?

I am having forgotten password hell. I have several look up files that are being accesed from my main file. When I select the appropriate look up file it then asks for the user name and password. I set the priveledges a while back and I can not remember the what I used, how do I get around this problem,help!!!!

Hi all, I want to do is: Can I create a password can only edit one of the field in records (I call it Date field)? 1) Password A --> Admin = access all 2) Password B --> User = can create record and can only edit the field (Date field) Any idea for me?

Please Help !! We have converted a 50 file solution from FM6 to FM7.. Everything is working fine. Due to the size and time restrictions of this solution we did not have the time to create a single database with multiple tables. We have sold our solution and provide support to them and we regularly provide updates. I was able to create scripts that when the administrator creates a new account for a user it creates the login and password in the other 49 files along with privelege sets that have been setup previously. The login is maintained in the admin.fp7 but the password is just entered into a global field and passed as a script parameter to be used as a setu…

I am using a program that was developed by FM Developer 6 and it uses the troi acivator plug in. My question is how can i enable the layout mode so i can do some modifications to the program??? the layout mode is currently not available(it is grayed out) any solutions are appreciated

i have a database that i want to limit the average user from editing records that aren't his aren't time (aren't billed OR aren't being prepared to be billed) so they have to be his time and not billed or being billed. for some reason i can't get the last part to work. i can get it to not let the user edit anything that isn't his time and billed but the OR BEING BILLED is the problem. i think the problem is syntactical. here is what i wrote: Created by = Status(CurrentUserName) and Expense = "Time" and (Billed = "No" or Billed 2 ? "Yes") and i tried variations of this to no avail. any help would be much appreciated. thanks in advance. …

I have a job tracking database that has 2 types of users. The first is the employees who have rights to view and edit all records. The second would be clients (via web access on server 7 advanced) that should only be able to view records (jobs) pertaining to them. The database has 3 tables. They are Jobs, Clients, and Employees. Each record in the Jobs table has a field marking possesion to a client. So...I have a great table of Clients, I could add a field with username and password. Can I get Filemaker to authenticate from records in this table? Does it require the scripting solutions I hear some speaking of? Thanks!

In one table, I want to be able to restrict users from viewing certain fields, unless they are the owner of the records. Specifically, I want each user to be able to view the 'company name' field of every record and search in that field, but only to view and edit ALL OTHER fields if they are owner of the record. This seems to be an all or nothing option in the Privalege Set. Does anyone have any insight to offer? thanks. _ MM

Hi, does anyone know how to disable the Windows menu without using Kiosk mode or having it in a continual pause? I want to be able to fully control how and when users switch files. I would also like to know if you can disable or clear the Open Recent option under the file menu. The reason I don't want to use Kiosk because I want to be able to use other windows functions, like switching programs, etc. The main problem is that each file in my solution does a re-login when it opens and takes the current username & password from the controlling login file. This works, but if a lower level user logs in on a machine a higher level user was using then they can acces…

I have a FM7 database running over FM Server 7. I want to allow users to print, but keep their menu access to minimum. However, when I set "Available menu commands" in "Other Privileges" to "Minimum", it seems to disable printing, even though "Allow Printing" is ticked. Any ideas how I can overcome this?

Maybe I didn't use the right search here, but here's the question... I would like to display a list of current users (accounts) for the admin. For example, let's say I set up Joe, Harry and Bob as users with passwords. I would like to display... Admin Joe Harry Bob ...at least to start. Anyone know how to do this in FMP 7? Thanks! Kevin

Hi 1- If I use Active Directory, for a group called "X" ,what will [get(accountname)] return? 2- where can one get the CDML 2 XSLT converter? tnx

I wanted to share a simple solution to the forum in how I restriced access to certain files. The database tracks the amount of money a person uses on a shift. The user enters their own information into the record. Once I have checked this information I wanted the file to be "locked" to all users who do not have admin privileges. This may be useful to those how monitor their database on a daily basis. First off there are two privilege sets: Admin and Standard. There is an openscript that limits what the user can do. Hide status area if not admin. All records are only accessed by button selections. Created a value list named Locked with UnLocked and Loc…

Dear All, I am using 2 fields to limit access to some records. Dept and School However i tried to use the limit records feature and specify Dept="science" , this works Dept = "Science" and School ="Snr" This doesn't work Wonder why the calculation field does not allow 2 fields?? or maybe i am just stupid. Thanks !

I want to enable a user to be able to see all of the fields for records they own (indicated by a "Record Owner" field, but for other users' records, I only want the user to see a few of the fields. Is there a way to do this?

Hello, I am running one Master Database with 7 related Databases it pulls information from. In order to set passwords for user access (16users), do I have to setup the passwords in each database independently? Is there a way to set it on the Master and it translate to the other 7? I have to restrict my users to basic data entry, but I want it to happen to the Master plus the 7. Thank for your time, interest and help.

In FMPv6 (hosted on Server 5.5) I want to be able to track the current user. I can't use the Status(CurrentUserName) function as the machines they are using may be public systems (this function uses the Applications setting). I have each user set up with a unique password and assigned to a group called "Faculty." I want to be able to use the PASSWORD (not the group) to look up the name of the faculty member in a table. From there, I should be able to set a global field or something that would allow me to use the name to track what they have done or manage their searches. Any ideas on how I can get the status of the current password in FMPv6?