Jump to content

How badly damaged is it?

This topic is 5704 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I went to a client to make a minor modification and discovered that the main file is in poor health. Symptom: I deleted a field definition and it crashed FileMaker. Yep, live served.

I went offline, made a copy, compressed the file, and still crashed. Compressed Clone crashed.

Experiment: I tried a recover on a copy and it brought back 5 field defs from years ago (when another programmer created this file).

Previous nights backup copy also has the symptom, so it's been this way for sometime.

I thinking I should go back through backups, find a file that does not exhibit the symptom, add back new fields, relations, scripts, and import the text data from the grumpy file.

Meanwhile I left it live, as there is no other choice, and was functioning despite whatever is causing said symptom.

I AM supposed to rebuild this on 8 very soon, but I don't want to rush that.

This is FM5 Windows served, Using FM6Dev on OSX4.

Opine away!

Link to comment
Share on other sites

Don't you have an original "virgin" file as these guys love to call it, Or do you simply modify the file live all the time?? If you don't, i suggest you export all data and restore it to an original copy.


Link to comment
Share on other sites

Apparently she's an old whore - I went back two years in backups, to the file prior to my hire, and same problem.

I had never tried to delete old fields I guess, mainly because I wanted to maintain the old reporting methods in case they were needed.

Yet another reason I kick myself for not insisting on a rebuild rather than work on someone's old files.

Now, considering they've been using that file (I do compress it occasionally) for several years WITH the undiscovered defect...

Link to comment
Share on other sites

Ha ha! Whether via ESP or good Googling, I had read your link hours BEFORE your reply!

I really wanted to delay this client's migration a few months. And I REALLY want to build from scratch, not migrate this ugly old thing.

Edited by Guest
Link to comment
Share on other sites

It is a good idea [color:red]Not to delete existing fields, even if you feel they are not needed. I usually just leave them be, or rename them to make them stand out incase I run into a broken relationship, script, or report.

Sounds like you are going to have to recreate your file from scratch. Any reason why not to upgrade to v8 at this time?


Link to comment
Share on other sites

I seriously lack the time, and I've yet to create anything as complex in 8 as I have done in 6. I was hoping to have more time getting comfortable with 8 in the smaller client databases before tackling monsters.

Why is there no icon of a chicken?

Bok bok bok! bok bok!

Edited by Guest
Link to comment
Share on other sites

This topic is 5704 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Tumma K
      Hello, All!

      I am an aspiring developer for Filemaker. The company I work with is stuck in the past working off of Filemaker Pro 4.1

      I was given the task of bringing us up to Filemaker Pro/Server 13. So far my conversion prototypes are successful but we recently had a layout issue that can only be fixed in versions 3-6 (as the file is an .fp3) I work off of a macbook while our network is all Windows 7. In order for me to repair the layouts without tampering our active database, I decided the best option is to repair a copy of our solutions off the network. Unfortunately, when I go to download the trial version of Filemaker Pro 6 off of the respected website, the file is corrupt! I've tried multiple times, with different extraction apps and in different directories.

      My question is;

      Does anyone know a place where I could obtain version 6 (or better yet, 4.0) for an OSX computer? I've looked everywhere!
      Thank you for your time,
      Tumma K.
    • By MrEddByrnes
      I'm hoping my question can have a happy ending. In the mid-90's, I purchased Filemaker 3. When Filemaker 5.5 Pro was released, I bought the update CD, which requires the user to either have FM 3 installed or to have the installation CD for FM 3. I've used it all these years, most recently with Windows XP Pro, and it has worked just fine. The databases I began with were long ago converted to FM Pro 5.5 databases.
      I'm still using FM Pro 5.5 on a laptop with WinXP Pro, but in 2013, I purchased a PC with Windows 8. I haven't been able to install FM 3 on it, therefore can't install FM Pro 5.5. I am retired and rarely use Filemaker, but I have a few Filemaker databases I'd like to add to my Win 8 machine. I don't feel it's worth upgrading FM for the sake of using a couple of databases.
      Has anyone else run into this situation and/or have a (possible) solution? Is there perhaps any other software that can read FM 5.5 databases? Thanks in advance for your help.
    • By bmill
      I am using a custom filemaker solution for medical office billing written with fp5 running on a mac with snow leopard. In addition, I have a patient management db (which I wrote) that is linked through pt. ID number to the billing program allowing transfer of some demographic information (name, DOB, etc).
      Other than being limited by hardware restrictions, the billing program serves our needs for now and upgrading to fp12 will take some time (and money).  In the meantime, I am upgrading my pt. management program to fp13 and would like to move new patient demographic information from the billing program ( fp5 running on snow leopard through Parallels) and the new pt management program ( fp13 running on OS X 10.9) on the same mac.   
      Ideally, demographic information would be entered once into fp5 and then a scipt would make the data available for fp13.
      Any ideas on how to make this work?
    • By randyinla
      Hi, can anyone tell me why my on-line database might have stopped allowing me to delete records?  All of my access privileges and passwords are correct.
    • By randyinla
      Hi, I still use filemaker 5.5 and am very happy with it and don't want to upgrade.  Does anyone still host filemaker 5.5?  Thanks!
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.