AnsweredAssumed Answered

Clients listed twice with duplicate Databases

Question asked by steveald on Jun 2, 2010
Latest reply on Jun 3, 2010 by philmodjunk


Clients listed twice with duplicate Databases

Your post

I am running FMS 10 with generally less than a dozen Clients connected, each running FMP 9, 10, or 11; and all running Mac OS X v.10.x (except one on Windows XP). Each Client usually has 18 databases open - 5 for regular use and 13 as hidden lookup files. This setup has slowly evolved over several years, so there is obviously some collateral code lingering around that is either untouched or slows things down unnecessarily.


That said, my issue is with most of my Clients showing up in the FMS Administration screen twice - once with all the open databases listed, and once with duplicates of a few of those databases. Which databases are duplicated appears to be related to which ones each Client uses frequently.


The problem it creates is that I run out of licenses. I am licensed for 15 FMP Clients and it only takes 8 Clients logged in to exceed that number when they are doubled up. For some reason this has only become an issue since we started trying to convert to FMP 11. I can't open our databases at all with my single license of FMPA 11 since it creates a second instance of me as a Client through routine use.


I can make the problem happen by starting up FMP and running the script that open all of our databases. One database immediately appears duplicated under a second instance of my Client entry in FMS. On my local computer, the duplicated database now shows up under Show Window with the database name in parentheses and no Server name shown (instead of seeing it listed by it's name with the Server name in parentheses, as is normally the case). When I try to select the hidden duplicated database under Show Window, it flashes on the screen and disappears. Then a second instance of the database appears - but in the format of <database name>(Server)-1. Then, when I attempt to view either instance of the duplicated database, they each appear normally.


Further, creating a new record in our primary database (the one with most of the Relationships to the hidden databases) results in a duplicated database in FMS; as does simply entering data in that database (triggering a lookup in one of the hidden databases).


Something else that has cropped up recently has to do with scripts that are set up to take data from a record in one database and create a new record in another database with that data. This has worked flawlessly until recently. Now, it results in a second instance of the target database opening (as if New Window were selected) and the new record with the transferred data appears there. This happens regularly now with one of the Mac's running FMP 10, as well as others.


I realize this is a lot of information, but I believe it is all somehow related. Any suggestions would be greatly appreciated. And more details can be provided, if necessary. Unfortunately, the ideal scenario of taking the whole system down and rebuilding it from the ground up is not possible - as it would require shutting down our business for the duration.