I have three databases which use frames. There is a local copy of each database and a replica on the server. Users may want to access the databases locally, or directly on the server. To solve this I have created 2 profile documents. One is a database profile and the other is for the individual user and uses the Key element. The personal profile stores the paths of his local copies of each database. The database profile, stores the path of the databases on the server. For every lookup within the three databases, it first asks whether the database the lookup is being called from, is on the server or local. If local it uses the personal profile and so on.
The frameset that is opened when you open the database, has a computed frame. This frame looks up to a view in one of the databases and as described will look to one of the profile docs to find the path of that database. Despite tests done to see whether the code is determining correctly whther the database is local or not, the frame still won’t load. That is to say, it will load on my machine, but not on anyone elses. Also again despite the test buttons working correctly, when on the server, the lookups just don’t work. No error, they just don’t work. For eg I have a form with a field which gets its title from the profile document. It just doesn’t pull the value down. And yet the code used in the lookup is the same code used in the button which says whether the db is local or not.
I’m obviously doing something wrong, or maybe there is something I don’t know about profile documents when on the server… if anyone has any ideas.