I am wanting to remotely open (on FMServer 9) a variable file name.

I start with a VB Script opening a shell FM9 database on the local PC.

Since a VB Script can't open a remote file, the VB Script is designed to pass the local shell database file the name of the remote file and the ip address of the remote server.

I then build the name in a variable called $OpenFile. One of my names looks like this:

fmnet:/10.8.30.100/ArtaCustomer

...problem is, I am trying to put $OpenFile in the File Path List under Edit Data Source... and it does not accept it.

Any ideas?

Right! ... have you tried this instead:

http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/popup_adp.php?p_faqid=5560&p_created=1130361369

--sd

I nearly chimed in on this one before, and had forgotten the FMP7: protocol - well remembered Soren.

The only problem I see is that you may try to open a file that does not exist or is closed on the server. This leads me to think that the file names must always be known, and therefore could be held in a database, then the $var approach would work.

Please also note the caveat on the fm help notice:

NOTE: If Internet Explorer is the web browser of choice, the "username:password@ipaddress...." syntax is only supported in Internet Explorer versions 3.0-6.0. Also, please be aware that storing credentials in plain text in URL strings can be a security risk. Example: leaving an alias or shortcut with this can lead to unintentional access to the database if the workstation is not protected.

Edited October 27, 200916 yr by Guest

Excellent. Thanks for that direction.

CCB