I have a little puzzling situation. I want to create an opener script, but no matter what I do to point to the hosted file in developer, it always points back to my local version rather than using the one on the server. I'm pretty sure this will work on a user's machine where there is no local version, but I can't seem to force it to point to the one on the server from my own machine. I've tried using both the server name, as well as the IP address. I've tried both with and without relative addresses. I've even copied the file over to the server, renamed my local file and then executed the "opener". I debugged it and actually watched it change the reference from the hosted file to the local file with a different name. Can anyone shed some light on this little annoyance?

Hi, mtnman! I'm afraid I do not have FM Developer, but one of our users had a similar problem with opening databases. She had a db system w/3 related FM databases that were named exactly the same thing (copies, actually) as the shared databases we use on our LAN. When connected to the LAN db's, the script to open db's on opening would open her local copies instead of the ones on the server (some kind of local override preference or something?). I opened another db in an altogether different location on her computer and then opened the LAN db's again and this time there was no problem. It seemed that once the "needed" files were out of FMP's default last/watched/focussed path, it then kicked in the designated server info as specified. While FMP's attention was on that local folder, though, it'd open those local copies every time whether we wanted them to or not.

Of course, your situation may be different, but you never know...

--ST

That's exactly what I'm seeing happen as well... It's really annoying, as it appears to randomly point to local files vs. using the files on the server. I've been very careful about how I placed the files on the server etc. I have a very large number of files in this application and it's really a pain to make sure that everything is really running off of the server. I'm hoping someone has encountered this and has a valid fix that I can somehow implement to make sure everything's correctly running from the server.

Delete or zip all other copies of the files, including backups. Be ruthless and methodical.

Alternatively use the FM Dev tool to rename the files in the solution to something unique -- I add a prefix to the names, like "UP_People.fp5".