Number of databases

[Bheywood]

We have 99 files that make up an ERP system for a small manufacturing business. Recently we upgraded from FM4 to FM5. I don't remember FM4 restricting the number of databases to 50, but FM5 seems to. Is there a way to increase the number of open databases? The server allows 125. Seems like a user would be able to access all of the files available. Thanks. -barrett

[DykstrL]

Unfortunately, the Desktop version (regular FileMaker Pro and Unlimited) only allow 50 open files.

Are all of the files (99) accessed all of the time? If not, you could set the files to open only when needed and close them when finished, to keep the total number of files open to 50 or less for the user. The only other option would be to combine the files down to 50 or less.

[Bheywood]

Currently they only open when needed, but how do you closed them when unneeded? Thanks.

[Kurt Knippel]

Define you sub-systems, then organize DBs, and open and close them by sub-system.

For instance:

All Systems need MainMenu.fp5, Prefs.fp5, User.fp5

Sales Sub-system needs Customer.fp5, Order.fp5, Line-Item.fp5, Product.fp5, Marketing.fp5

Billing Sub-system needs Customer.fp5, Invoice.fp5, Payments.fp5

and so on...