Security Concepts

Somehow I accidentally turned on "Log in using" Account and Password. Boy was I surprised when FM asked for Account and password at next launch. By duplicating my mistake on a scratch file I was able to figure out that the Account had defaulted to "Admin" with no password and I was able to log in. I have now UNCHECKED the "Log in use" option on the File Options panel but at launch FM still requires the login. How do I "remove" the login requirement?

I am currently using a "Created by:" field, using the Get(AccountName) function, but I would like a "Modified by:" field as well. Any ideas on how I would do that?

One of our clients messed up their checkbook file and wanted it restored from a backup. We restored the backup file, and now when he opens it, it asks him for a username and password. The client says that he never set a username and password for the file. We have tried Admin and no password, no username or password, and his normal username and password. I have used a Filemaker password recovery program, and for all of the other files, it has a username of Admin and n/a for the password and says they are not password protected files. The checkbook file has n/a for both username and password and also says it inot a password protected file. Does anyone have any idea what we …

I have a login script that includes a Get( PrivilegeSetName ) in an If statement. When I run the script, I can see in the Data Viewer that the desired Privilege Set Name is identified by FM but when the login script runs, the If statement that checks that Privilege Set Name gets skipped. I've changed the Privilege Set Name, changed the Account Name, cut-and-pasted the name from a Boolean test in the Data Viewer, flushed the cache and moved the If statement into a subscript. Nothing helped. I've also copied the If routine to a different script with negative results but if I do change the If statement to check for the "[Full Access]" Privilege Set, and login …

Is there a way to import database users from file into another so that I do not have to recreate all the accounts on each file in my solution?

Hello everyone. I apologize if this is the wrong forum to post this in. I'm having a minor issue with a db I have recently created. I have created a database that my dad uses to track his clients and inventory. As he has several employees who use the database, I have created user names and passwords for all of them to use. Upon a successful log in, I want the current account name (their user name or name) to appear in the top left corner of the screen. I thought the symbol "||" did this, however it seems that it only displays the user name defined in the preferences panel. How can I make FileMaker display the current account name that is logged in? This is a fea…

I long ago converted my files from 7 to 9 and revised the access/security for them. All my files, that is, except 1 which is in an ancillary part of my solution. This one file had been stable for years, executing in runtime. I required a username/password to access the .fp7 version of the file, but not for runtime. I need to access that file now, but cannot remember and cannot find the user name and password to get into it to review some scripts. What can I do to break the security?:?

I use Filemaker at work and wanted to start using it at home. A friend at work set up a database for me, so that I would not have to build from scratch. I did not have a chance to open the database for several months, and now have tried, but it is locked with a username and password. My friend does not remember applying security. The tech support at FileMaker suggested I check this forum for ideas or help finding a service to retrieve the username and password.

I have the following problem: How can I inform users that their password has changed BEFORe they try to login? (besides sending an email)?? Here's the situtation: File hosted on Server, with about 20 users (privilege sets: Data Entry or Manager). I am upgrading to new version; have transferred all the data, including the account names from old solution. I am recreating these account names in the new solution, but I have to set the password to a generic one since I do not know it (or leave empty; user has to change it after first login) . Unless I send out an email to warn users, first time they try to login, they will not be able to.... is there a way to let th…

Is there anyway to return the rights that a selected user has? Not the current user, but a selected user from a list. I have my user setup layout, where I add users and accounts, but I would like to list what privilege they are assigned. I know I can set a text entry into a field when I create the account, but was hoping there would be a way to put the Get ( PrivilegeSetName) into the field, which should be more foolproof. Using a calc field returns nothing - the new record trigger occurs prior to the account being established - I think that is the problem with that approach. (the whole concept of how to trigger GET functions is perplexing - why are func…

I created a database in fm 7. The access privileges are now preventing me from making any layout changes. The Define area on the menu is grayed out. Can anyone help?

Our IT guy recently quit, leaving me to learn and maintain our FM Database. BUT I dont know the passwords, and he doesn't recall them any more either, I really don't want to get into the password cracks, what would an uninstall/ reinstall do?

Is there a way to restrict access to records on a user by user basis? For example, I'd want a user to be able to view, edit, and delete only those records that he/she created?

Are there any tools out there for Mac which enable me to get into a FM file to reset or retrieve existing passwords? I need to get into a FM solution from 5 years ago and nobody remembers the passwords. I found a couple freeware/shareware/etc. apps, but they're all for Windows (which isn't available at this time). Anything available for Mac?

I am building a front end to a database that will be used for iwp web access. I have the basic structure in place already. What I am wondering is can I have a script that opens the back-end with one user, no matter who logs in to the front end? That way I will not have to create new users in the back end, but rather just have a single web-user account. The front end needs separate users, who are then directed to a certain layout by a script. I am sure this must be possible but I have not been able to find a thread on it yet. Any help would be..err..helpful

I have several accounts with conditional privileges set for editing records. At logon, I am running a script that determines which records a user should have access to and puts these values in a global field. The Edit privileges reads this field to apply the right privileges. When a user needs access to a new record, they execute a process that adds the new record value to the above global field. The issue is that when a new record is added through the above process, a user must log out, then log back in to have access to it. However, this should not be required since the conditional privileges should read the new record when it is added to the global field? …

Is there a way to create a log file that will show me when a user logs into FM Database and when Log Out? I am using FM Server 8 and FM 8 - 8.5 on workstations Thank you, Joseph

Hi, I work on a database that originally was fairly simple but over time has had more and more components added to it. The relationship screen has gotten to the point of incomprehensibility. The solution we have come up with is parsing out various elements of the database into other files and then linking to them. This has made things easier to keep track of. However, it has created the problem of users having to repeatedly re-enter their userIDs and passwords only to be told that it is incorrect. The problem is that different people need access to different files. What we need is a way where the user can sign on once, and from there he is automatically logged o…

Hello. I am a network administrator for a small company. The company just started using FileMaker Server 9 and FileMaker Pro 9. We two offices with the server located in one with 7 Computer with FileMaker and the remote office has 2 filemaker acconts. I want to enforce a password policy to control the length and complexity of everyones passwords. I do not know much about filemaker and I am having trouble setting it up. I would just use external authentication but most of the PCs in the company are XP home. That makes it impossible for user to set the passwords them selves. And I can't force them to change their passwords through Active Directory. If anyone knows how …

hello all... i have created 3 user accounts and 1 admin account in my projects. user accounts have min-level-access/privileges while admin account is full access. everything works fine as expected. however something happened today. i opened the file and got the login dialog-box to enter username and password. instead of loggin in, i clicked on cancel button to not log in. and instead of closing the file, FM not only opened it but opened it with full access / privileges. its very strange that it happened. i there any any way to fix this so that when the user cancels the login box it closes the file instead of opening it and that too with full access / privilege…

I'm using external server authentication for single sign on. If I'm logged into the domain, is there some way to bypass SSO so I can log on to an internal account? Thanks, Moses

I have set up a database with guest access and the privilege set to allow the creation and editing of records and with guest account set up as the entry point. The system is set up using php with fmphp enabled and I can view and find records but not edit them. The error message is: Error: 200 - Record access is denied, which suggests a privileges violation. If anyone has a checklist or similar to troubleshoot the access problem, I'f be very grateful. regards, George

Hey all, maybe I'm missing something simple, I have 60+ databases, all were hosted on FM3, I came into the company, converted everything, upgraded to FM9, and I'm applying users, privileges, but for some reason, databases won't open with a password prompt, I've checked the file options, I know I can use option open, but I don't want users to do that. I have a splash screen directing to databases, who goes where, can do what.... What am I missing? thanks Hank101

I know I saw an answer to this question somewhere on here but I couldn't find it after extensive searching: How do I replace text with bullets/dots in a text field I'm using for a secondary login screen? (I think it involves using a bullet font.) Since users will be accessing the solution via the web, the Custom Dialog route won't work. Thanks! Rich

Hi, My client is a Bank, and they have a standard policy that if a user / password fails three times, the user account must be locked. Also, every failed login attempt must be logged. I know that with server, the failed logins are recorded in a log (along with a lot of other stuff...) but how do I lock out a user with three failed logins? I'm not using (read I have no idea how to use) external authorisation. Is there a way to do this in Filemaker ? thanks

Ok, so I created a database in FMP9, set an administrator username/password with full access privileges. To make it easier for other people to test, I set it to "Log in using Guest Account" in File Options. Of course I exited, went back in and was automatically logged into a guest account. Now I can't figure out how to log in with my admin password and seem to have effectively locked myself out of my own database Any solutions?

I have install FM Server 9 on Virtual Machine running on Windows Server 2003 and also FM PRO 9 on my 14 PCs. I only want to have 2 user to be able to Read/Write, how do I do that? I tried the PDF file that FileMaker Provide but didn't help.

I have just started trying out the data separation model and have an issue that i would like some suggestions on. I would like to have a flag that i can toggle at the record level to allow/disallow editing of fields. I have a privilege set "User" that is allowed to edit when the flag is 1, not when 0. However because the data is in a separate file, running the toggle script with "Run script with full access privileges" in the UI file obviously doesn't work cause of the data being in another file; however, when i run the same script in the Data file, i have a script context problem. (Have to perform a "find" to modify the appropriate record). So to recap, just loo…

Hi All, I disabled some of my scripts using Accounts & Privileges. Scripts are attached to a button, when ever i click the button a message pops up. My question is, how can i disable the error message? I tried putting Set Error Capture[on] to the script but error message still pops up. Thanks all.

Hello again. How about hiding practically all of the little icons and toolbars other than those used for navigation? How do I do that? I'm thinking of something like a lockdown that would force the user to only use my scripted buttons instead of the FMP interface. Thanks.

I've got a simple FM runtime solution that uses the Scodigo PHP SmartPill Plugin to make HTTPS post calls to API services like eBay and PayPal. Sometimes the data included can be sensative, like credit card numbers. The posts go to PayPal's HTTPS servers, but I know I need my own SSL on my web site when dealing with credit card transactions anyway. With FileMaker there isn't a web browser involved. Is this secure? Any information I can get on this would be greatly appreciated. I just want to make sure everything is as secure as it can be as far as encrypting sensative data goes.

We are working through the issues of PCI compliance and need to add encryption to some of our fields. Question: If a literal string is included as part of a script step, like $key = "ASD87654", when the script is saved is that literal stored as clear text in the FileMaker file or is the script compiled somehow masking or converting the literal string to something that would not be recognizable? Same question for a function, is the function compiled so as to mask its contents? Or, in the context of the FileMaker file being read in a text editor, is this a non issue? The files are secured with a developer's account and users will not have access to the script …

I have several database files created on a Mac with FM Advanced 9 under a username/password with full access privileges. The Mac's HD was damaged and not retrieved -- but all files had recent backups. Now with a completely new Mac I've reinstalled FM Adv 9 and now can't seem to figure out why I can't access database files that were secured under the username/password on the previous Mac. I have the username/password saved elsewhere so I know they're accurate. I'm guessing the account needs to be created, but you can't create the account unless the particular file is opening. Any help appreciated. TIA

Is using Get(AccountName) an advisable key field? I have indexing checked on "All" in both tables. Lookups then function and are a useful part of the solution. Should I anticipate that users will need to change their account name in the future? Also, my users login to create content. The content that they create is modifiable by them, and readable by others per calculation in Manage Accounts and Privileges (Get(AccountName) = Get(AccountName)). So, there are two reasons why the account name should never change. Is this a poor approach? Thanks, Jason

One of my clients has an employee with the fastest draw in the building---he or she has developed a nasty habit of the Replace Field Contents keyboard shortcut and an even nastier habit of just hitting enter and not reading warnings. Is there any way to block or disable that keyboard shortcut? I'd assume I can do this through custom menus? Thanks!

I am working on a FileMaker db which contains a lot of personal information. Creating forms and account privileges to hide this data is ok, but how safe is the fp7 file password at log-on from hackers? The files will sit on a secure part of the Server, but my user asked how safe is their Admin password from IS or others taking a peek? Can anyone get a back door crack? Any info welcome

This is a really basic question. Sorry. I'm setting up a new database that will be web published. There will be over 300 users who need to be restricted on a record level. Is there a quick way to set up these accounts and limit access?

OK so I can script the creation of Accounts & Privileges but is there any way to transfer Extended Privileges? It's a real pain if i can't. best Stuart

i have an instance where i need to have the same field secured differently for different users based on a specific record. i do not see any way to do that. i can restrict the whole record by setting the security but not setting different security for a user for a single field. any suggestions?

I did a quick glance around looking for this, but found nothing on this topic. I am running FM6 and my boss wants to purchase 9. I am trying to open a fairly complicated database and have run into two problems. I cannot go into our existing/functioning program on our file server because I am not going to mess something up and render the backbone of our whole program useless... so I copied a last years to my hardrive and tried to open it. It will not open. When I tried to convert it to 9, I could not get it to work because of the password. Any ideas>??

I’ve a FMpro 9v03 database where i’ve used in a script the function ‘Get useraccount’. The result of the function is always ‘Administrator’ even if another user connecting the database. In the list of the accounts&privileges are many different users with a name that match the names of the employees in the database. The database hold information about the absent of many employees. I want to make a startup-script that give employees the possibilities to view their own information (without viewing the rest of the information of the other employees). Can someone tell me why the function ‘Get useraccount’ don’t give me the name of the account who’s visit the database? …

Hello. I'm trying to set up outside access through IWP, but I'd like to limit the ability of salespeople to view/edit only their own categories. For example, Jack should be able to view/edit only Agricultural companies, whereas Mike would be able to view/edit only the Mechanical companies. Head office should be able to access the entire DB. Any ideas? Thanks!

Hello: Greatly appreciate all the assistance thats been offered here. My latest question is as follows: I have a layout that contains a variety of fields that are completed by one member of my agency. The rest of the members need to be able to view this layout and the records that it contaions however I want to limit the changes that they can make to just one or two fields is this possible? I have tried to play with the access privelages and such but have had little luck figuring it out TIA Opie

I'm just starting a new database. I only have one table 2 layouts and no scripts. I've created a simple Privilege set: Records: Create, Edit and Delete in all tables Layouts: All modifiable Value Lists: All modifiable Scripts: All modifiable These are the only fields I touched when creating the privilege set. When I try to log on I get a message box that says.... "Your Access Privieges do Not Allow You to Perform This Action" Uhh....What Action?? I'm not running a script at file open. The file is about as "bare bones" as you can get. I don't get it! (Obviously)

Forgive my density--and I feel a little sheepish asking this--but why is it that in the Edit Privilege Set windoid you can disable the "Allow user to modify their own password" privilege, yet when an end-user signs in to a password-protected solution he or she can still change their password, anyway?

I have a database located on my server (not filemaker server)at work. I can't open the file and it keep giving me the following error message "do not have sufficient privileges for abc.fp7" Any idea what can be wrong with the database? Any help will be appreciated and thanks in advance.

Howdy, howdy. Don't get up. I've assigned four different privilege sets for the users that'll be using my solution (Admin, User, Reporter, and View-Only)...which is all fine and well if you have a few users. However, the User group alone will have 50+ separate people using it, so creating 50 account names (user1, user2, user3, etc.) is a klunky, and limited, way of doing things. Is there an elegant way of assigning semi-Full-Access authority to an Admin account name so that person can create and assign accounts to his co-workers and underlings without getting into the guts of my solution? (I _definitely_ don't want the Administrator to have Full-Access authorit…

Greetings, In my quest for security I will put the database connection php files in a directory called private on the server. so the directory stucture looks like this httpdocs httpsdocs private How do I reference a file in private from a file in httpdocs Thanks Pete

Greetings, About to deploy a fm and php seminar registration system where our staff access the db via filemaker and the customers make bookings via a php webpage. What I've read tells me to watch out for these problems on the php side: Rubbish data - I've got input validation on all of the fields, but ultimately if someone wants to submit rubbish there is little I can do about it as the validation only checks that the email address is the right format and that the fields are not empty. Cross Site Scripting - I'll strip out all tags before allowing the anything into the database DB connection information - I'll include the connection as a separate …

I've finally set up an FMP file for public exhibition - having worked on it for a good while. The last thing I wanted to do before signing off on the file was to lock it down so that users viewing the data wouldn't be able to change things - either by mistake or (mis)design - so I changed the Account privilege settings and created a new (User) account which loads automatically with a script when the file is started. Worked a treat, and everything was fine until I noticed a few things that still need tweaking - a link goes to the wrong layout - small things like that. However, the "view Layout Mode" is greyed out for this Account- so I can't get back in there to make a…

This question doesn't really fit into any listed topic so i'm putting it here. Today I uploaded a fmp9 db to fm9 server for the first time, in order to demo it. As I was using it, another user logged in thru his machine. both he and i were using the same copy of fmp9. at one point we were both logged in. then he logged out and logged in again, but this time got the message that said the limit had been reached for # of users with that license. I thought the # limit was 5 or 9 or something like that. not 2 or 3. And why did it allow the two of us the first time, but not the second time?

Hi wondering if anyone has run into this issue. I have some log ins with mainly data entry permission. I do not want them to be able to modify the value list, only use them. But if the field set up is set to allow edit in the value list, the person can go in through there and change the value list. Do I need to turn off the edit function? I want people with full access to be able to edit the value list while in the drop down or pop up menu. Thanks for the input.

Is it possible to disable all shortcut keys? i.e. Ctrl F, Ctrl N etc. etc. Thanks, Sully

Hi guys, Probably a really simple one for a change. where abouts is the file kept that remembers a users login name? One user has a ' in his name but file maker always leaves it out and he needs to manually enter the ' all the time, i want to edit the file and add the ' so it remembers it. Not a major issue, more a small annoyance.

I created my first database, a billing log for my wife, and had everything working fine. I then move it into my wife's account (on the same computer). Whenever she tries to access it, she gets the subject error. I can still access it from my account. I have admin privileges and she has Write data only privileges in the file. I have set permissions on both Filemaker and the file to allow her access. What am I doing wrong?

I was working on a new database and was putting the finishing touches on it today when a large problem happened. The file was on a flashdrive and I was distracted and not paying strict attention when my PC crashed. When I got things sorted out the flash drive had become unaccessable(SP). I was able to recover the file but now it is asking for a login. The file never had a password entered and when I try a password recovery hack it says that there are no passwords to recover. I also tried to recover the file using both FMP 9 and 8.5. The recovery went OK with no errors but when I try to open the files I get a message saying "The Access Privileges in this file have been dam…

Hello, I am new to FileMaker and I am having difficulty connecting to a remote server. The "available files" do not appear. I entered the URL of the server and all seemed to work fine at this point however in the field at the right there is a list of "available files" which never appears. I am assuming my hardware firewall settings on my router are not letting me access the remote FileMaker server I need to access but I am not completely sure. Lets assume that is what is causing this inability to connect - a firewall issue. I need to break through my firewall somehow but without comprimising my security. I have not using any software firewall programs - just my Links…

Hi Historically, I've built a number of 'Business Tracking' type solutions as an employee and therefore have been 'available' should tweaks be required, either to the database design, or to the accounts administration. To this point, these solutions have only had a maximum of 6 users, and whilst having deployed Server on one occasion, dealing with adding accounts has never really posed a problem. However, I am now in the fortunate position of building a solution for a client who wants to use Server, and although there will initially only be a handful of user accounts, dozens more will be required in the long term. Helpfully (or otherwise), I'm using the sep…

So how do I prevent someone from using their own copy of Filemaker Pro, creating a database, identifying my hosted but hidden database as an external data source and then browsing any records in the file?

We've been having our clients regularly validate their databases: when a certain period expires, the client is prompted to validate, and an encrypted email is created that contains the timestamp of the request, the server IP, and the current expiration, among other information. They send us the email, and we paste the encrypted string into our Client Management database, which checks their stats against our records. We then send them another encrypted email back that contains the timestamp, the server IP, and the new expiration, which they paste into a dialogue box to complete validation. This procedure helps prevent the database from being installed on u…

All my files are popping up the login dialog box when I double-click them except one. I went through the Account & Privileges and the File Options and found no difference. Settings are the same. Any tips about that !

Hi, If I have four fm7 files and I want to end up with just 1 fm7, how do I import the accounts & privileges? I know how to import the tables, etc... My privileges go down to the fields and yes, some of my field privileges are set to view/hide on a per user basis for some accounts only. Please tell me I don't have to set it up for each field/user again? : Thank you.

Once a user has logged in, I can use the Get (Account Name) function to validate their identity. But more than one user can have the same account name, right? So if I use the account name as the match field to a related table, then the match field may not be unique. How do I authenticate a user upon logging in, so that I can pull related data (based on that user) from another table? Thanks, Jason

I currently have FMP9 solutions that I am using with Exeshield to provide copy protection for the PC platform. Does anyone have any suggestions for a 3rd party product that provides anti piracy protection for the Mac platform. Thanks

Helping a friend with a database and he doesn't seem to remember adding a password protection to any of his files but when he emails a file to his other computer the file ask for a password. Is there anyway to set the privileges to a file to full access without know the password? Thanks,

Is there a way to change password for a specific user on multiple files at once? also is there a way to add a user to multiple files at once. Thanks.

Greetings, I'm about a week in to my first FileMaker DB, and I'm confused about something. I know how to set the user name both simply through preferences and through Accounts menu. What I need to do is assign extra attributes to each user. I created a users table, when I try to access data through that I doesn't filter down to the active user. What am I doing wrong?

Hello Everyone!!! I just started using FM Pro Advance on XP 2 days ago and I need to create a database where all company personnel can go into and fill in their personal details. The thing is everyone is only allowed to access their own personal database and no body else apart from admnistrators(me). I know this sounds very easy but I am very new to this kind of work and i need help. My questions are do I have to create an ID for every single person(so they can go into the database and fill out their details) and if so how do i get them to only access their own "record" and nobody's else?:? :

Okay, folks, I am desperate. The shortest summation that I can give is that I have been having a fight against giving Full Access privileges to a user who has been proven to all (except those in charge) to be incompetent. This person only wants control over others, not to be able to usefully share needed information with the rest of the team members accessing the database. I have been in the crossfire of this admittedly personnel problem, as opposed to an actual DB issue. What I am looking for here, then, are some solid, non-emotional arguments for limiting access, especially to defining fields. The person in question has had limited experience with pre-V7 ty…

Hi, Just recently encountering a problem opening a FM 8.5 file on Leopard 10.5.2; I'm prompted as usual for the username and password which I enter. FM returns the following message... "xxxxx.fp7 could not be opened. (Not Open)" Any idea what might be causing this issue and how to resolve. TIA. Jack

Hi all, Currently at work here we have a very messy database that has NO security, the previous database guy left the database in a shambles and we have over 150 databases we need to implement security on. At the moment, if anyone wants to enter some data, everyone in the company shares the same login, they can edit, delete and create new data, its a nightmare. So we are implementing individual logins based on Active directory, however for the time being we want to create 3 log ins. Developer access(can do everything), Data Entry(without the ability to delete records) and Data Entry(with the abitlity to delete records). Now we were testing this out yesterda…

HI geeks, Is there a way to set new passwords in File A and implement those passwords through a set of databases used with File A instead of changing manually the others databases? Any help is welcome

I do not know if I am overlooking something or its just not there. Now, I know that Get ( RecordAccess ) returns 0 to 2. 0 = no access 1 = view only 2 = edit access Although this function seems incomplete because you can define a delete privilege, which can differ from the edit privilege. I need to be able to find out if the current user has the ability to delete the current record without executing a delete command. Thank you in advance for your help! :B

I am unable to open files that I copied from our server (FMS 7)to my laptop. I get the message "The account name and password you entered does not match those for any Filemaker account". I have tried using several user names and passwords that work at the office via the server but none work stand-alone on my laptop. Also, the guest account is greyed out. Is there an issue with moving files from the server to a single user machine? Any way to work around this? Thanks

How do you lock a record ? say after 2 weeks you want to lock a record how do you do that ?

I have a small application that is getting a lot of interest within the special interest group I created for. I am looking to distribute it but want to insure this won't get passed on. I need to create a serial number or unlock key. I know how to to crete on from a table but does anyone know any tricks on how to make one unlock key work for one computer but not for another? Any tips or tricks or suggestion? I would even consider third party solutions.

OK, I'll admit it. I'm an idiot. We have an old database that we only need to view, so I changed the automatic login account to View Only permissions. I believe there is an admin account setup, but the database is set to use the default login automatically. So now, I can't get in a do anything with the database. Is there a way to force login as a different user? Like I said, under file options, I have it set to login as a specific user. I don't see a way to login as a different user. Any ideas? Thanks for the help.

Background: I'm coming from ClarisWorks which I know inside-out and have been using for years to run the company customer database. I'm migrating from Mac OS 9 to Mac OS X (Tiger) and specifically chose FileMaker Pro as it looks and feels sufficiently similar to ClarisWorks to make the migration as easy as possible. (I'm talking about a database of ~1000 entries here.) Yesterday I loaded FM for the first time and spent four solid hours in familiarising myself with it. Fortunately I was using trial data. Today, to my astonishment, I cannot open yesterday's file. It keeps asking for my Admin password. I supply the only password which exists on this computer b…

I've been looking for hours but still have not come across any posts that tell how to lock records. We will have a number of records being shown in a portal. When the "Status" field is set to "Complete", I want to prevent anyone from making further changes. Up till that point, it is fine for them to make changes. It seems like there should be a function called "lock record" or something like that, but I can't find anything. Could it be called something else? I'm using version 7 and version 9. BTW, 9 has some great new features. I was glad we bought it. Thanks for the help

I'm working on a solution where i want to be able to basically create my own user access policy. fairly simple procedure, just create a separate user table, separate access level table, and common table between (as i would with PHP) and just set different access levels to have separate functions. easy for the most part. The reason i am looking to do this is administrative function from within the solution, and works in a standalone solution easily. Is there anything i'm missing about the built in user functions? Also, i'm a little stumped with creating an auto-generated username. i've created a calculation that makes the UN "Firstname.Lastname". works just fine.…

My file which i have been using for a long time, suddenly became non modifiable this morning. The file is hosted on our X-serve running Tiger 10.4, but FilemakerPro 8.5 is actually hosting the file. (One of the drawbacks is the server will sometimes disconnect me and give me error messages until I close the file- reconnect- and then open and everything is fine.) I was notified by one of the IWP users that they could no longer edit the fields that were fine yesterday when they went home. Upon confirming this myself, i was trying to check on their account privaliges I got the message that it was not modifiable. After looking through our forum I had …

I made a system a while ago and now can't go back in to edit it. When the database is opened it doesn't ask for a password or username.... so cannot access layout in the file. Can anybody help, Manage in the file menu is greyed out also and when I go to open/close in the preferences, it tells me I have insufficient privileges to change.

I would like to allow remote users access to our LAN including FM services through SSL VPN. I wanted to find out if there are issues with FM compatibility in this scenario along with any advice about bandwidth requirements, or anything else. Up to 10 users will be connecting remotely with Mac clients THe hardware I am considering is Netgear's Prosafe SSL312 SSL VPN Concentrator, and the Prosafe FVS318 VPN Firewall. Thanks in advance

Hi there! My company has a FM database which was created long before my time and we've found ourselves in need of the admin log-on and password... which we cannot find. Are there any work-arounds I could try? This database is vital to our daily business and I'd appreciate any thoughts or ideas!! Thank you! - Jamie

I am planning to release a FileMaker DB which will allow users access to ScriptMaker, certain Layouts, Tables, Fields, Relationships Graph, Value Lists etc.. without giving them access to the [FullAccess] account. I have managed to achieve this by creating a series of scripts using commands such as (Open Manage Database and Open Manage Value Lists). Which will allow a non [FullAccess] account user access to these development tools. However I have not managed to find a way to give a user access to the Custom Menus or Custom Functions part of the DB without giving them the [FullAccess] account details. Does any one know any tricks I may have missed?

I am about to release a run-time version to a client and wondered just how secure it might be. I did some research and found out that there is a piece of software that claims to remove all password protection from Filemaker. I was freaked out until I noticed that "databases protected with filemaker developer are not supported". That eliminated my concern but may be a blessing to you. Check out this link and four $45 you may have your database back! http://www.lostpassword.com/filemaker.htm

Hi, I want to share XML data from FMS, but I dont want every body can access the data. The user can access data from filemaker runtime file using xml importing option. What is the best way for protecting my data from non-authorized users?? Is it possible to show password prompt, or any other methods. Thanks in advance

This must be simple but I would like to get a list of user names how would you do that ?

I would like to lock a users records after 2 weeks, so in the Priveleges section on the record tab I have limited the priveleges so that initialy only a person who created the record can edit it, I would then like to limit the time they have to 14 days.... I have got this far... creator = Get(AccountName) + date Entered ≤ GetAsDate ( text ) + 14 Of course this does not work ! but I think you can see what I am trying to do ? can anyone help here ? Thank in advance....

Ok I have a nice login script now... However I would like to do a seacrch on login to return only those files which are the users own files (unless admin of course). So that the user does not see any "Access Denied" records. this is proving tricky for me. I have a field that is filled with the users user name on record creation and this is a hidden field so I would use that this field is called "creator"... anyway thanks for any help anyone in advance.....

FM 8.5A , all on Windows XP Home/Professional We have a customer who need a local copy of our main Customer database on their company laptops. The database consists of about 12 tables across 3 files, approx 125 MB in total. We need to look at the hypothetical possibility of a internal staff taking a copy of our Customer database and sell to another company. What is the best way to lock the database so it cannot be copied, or cannot be run on a non-approved machine. Thanks, :)

Hi Gang! I have a database of customers. This database contains indicators and the names of other online FM Pro databases they have access to that I host on FM Server. This database also contains their username and password in text fields. I would like to be able to create their access to the other databases from within the "Customers" database - and was thinking that it would be much easier to have an ON/OFF toggle type script or function that would allow me to activate or deactivate their access, rather than the current way we do it, which is to add them as users to each database and put in their username, password, click ACTIVE, etc. For instance, two…

Hopefully this hasn't been covered already (I looked, but couldn't find it so I apologize if it has been covered). I am running Filemaker Pro 8 Server Advanced on a Mac with Custom Web Publishing. Right now I use Filemaker Authentication (i.e., not External Authentication) and individual Usernames and Accounts. Is there any way that I can limit the number of logon tries via the web to a certain number (e.g., 3)? I can't see any way to do it via the Define or the Configuration, but need to do this for the Security Requirements that I work under. Thanks. Shirley

Hi experts, I have a simple question. I have a inactive account in my file. Is it possible to active this account from external tool ( applescript, vbs, ...) ? Thanks in advance Ann

I am currently building a system for a company that does not want me to see their data. Is there any way to lock myself out of viewing the data but i will still be able to define fields etc...?

OK I have a login script that searches records and the result is that only those records that the user created is returned when they login, however the find function does not seem to work, the field I use called creator uses the function as shown here it is.... and the field used to refrence the user loging in has it's field filled by this... Any suggestions ? I know this should be easy...

THis should be easy but it is not looking easy, I want users to ONLY be able to view their records i.e. ones they create NOT ANY OTHERS. How would I do this fairly easily, it does not do it out of the box I see.

Ok I have a database and want users to be able to edit their own records but not others, so when they log in I would run a script to only view the users records i.e. do a search and restrict the output to only their records. if somehow they manage to view others records, I would like to Get the user name and tie it to a field created on the record when they create it which contains their user name. I have actually done the field creation and the users name is inserted into the field upon creation, however I cannot seem to find a way to get the name of the "Current User" and use it to find only their records based on the field with the user name inserted when the record …

Hi, Our system is being hosted on a machine that has FM Pro 9 Advanced installed. Users connect to this using "Open Remote File". I want everyone to have username and password, because there are different previliages assigned to each user. How do I make it that whenever they open the file, FM should ask for the usernmae and password. Regards Mitesh

So I recently upgraded a production system up to FM9, and immediately (within 12 hours) came across a disturbing issue where a script keeps calling itself in a loop even though there is no loop and no recursive call. At first I thought I'd found a bug in FM9 since using the exact same file with fm8 or fm8.5 did not show the behavior. But copying and pasting the script steps from one script to a new empty script makes the problem disappear, so I guess the file (or at least that script) is corrupt. I've attached the file in case anyone wants to have a look. The username and password for the full access account are both "root". There are instructions in the …