Thanks to a very valuable comment from Vince, one of BentoUsers’ reluctant followers, I would like to give you the how-to of archiving sub-sets of your Bento database.
My personal example is the collection of race reports from my daughter’s High School sports career.

Here’s the step by step:

  1. Back up your current (complete) database file
  2. Create your sub-set of Libraries/Collections by deleting unwanted data
  3. Quit Bento and re-start which now automatically creates the finished sub-set
  4. Now, back up this new database file, naming it anything you want which creates the archive
  5. In Bento, revert to the back-up of your main database file
  6. Repeat those steps to create more sub-sets

Possibly you might also want to reduce the size of your main database file by deleting the data you saved in your sub-sets.

Note: in my case, my data sub-set consists of iCal Collections. Since Bento has a two-year limit for displaying iCal events, I also saved the Library Records separately as a .csv file. I hope that will work to trick Bento’s iCal limitation. The future will tell. Any comments appreciated!

Newest bug discovered: when you delete a Library, the size of the database file doesn’t change! Apparently all Bento deletes is the reference to the Library, but not the records or the media!

Since Bento 3 is so unstable, I decided to create sub-sets of my database for archiving purposes. For example, my daughter’s High School sports career is over, so I don’t need to do much more editing on her race reports… but one of my objectives was to reduce the size of that sub-database which Bento didn’t do!

Update: (see comments)

I have no choice – I just created a new category: Bento 3 Crashes! I still can’t believe how unstable the app is. So please comment in detail on the crashes of Bento 3 and I will create a new post for every crash reported.

Today I was using my Library “German Legal” to practice my vocabulary to prepare for my next court case (I’m an interpreter). I had set up a Smart Collection for the words I need to practice. It includes a Check Box field entitled “needs practice.” As long as this box is checked the words remain in the Smart Collection. Today, when I tried to un-check the box, Bento 3 crashed! Luckily, my database file stayed intact (it seems) when I re-started Bento, but the same thing happened again! So now I can’t use this set-up for practicing anymore!
Bento 3 is not able to adjust that Smart Collection. Big bummer!

Summary – the crash trigger:
trying to remove a record from a Smart Collection by un-checking a Check Box field. This had worked perfectly in Bento 2.

Update (12/09): this bug was specifically addressed in the Bento 3.0 v2 upgrade and has really been fixed! Thanks Ryan.

In case you didn’t know Filemaker offers free (limited) tech support for Bento by phone. You can also report crashes and problems, of course.
The number is: 1-800-325-2747.

For more details, see the Filemaker Contact page.