1 2 Previous Next 17 Replies Latest reply on May 4, 2016 11:30 AM by sstramel

    Help needed to access Remote database

    sstramel

      We have FileMaker Pro 14 installed and have 4 databases.  One PC is a dedicated Host and has all 4 of those databases open and shared to the clients.  If we go to another PC that has the same version of FMP installed and do an OPEN REMOTE, we see the 4 databases listing in the Host tab.  If we click on any of those databases to open it on the remote PC, we get a blank message box popped up with only an "X" icon and an OK button, not message.  Clicking OK the message box goes away.

       

      It is hard to determine the issue when there is nothing in the message box.  Has anyone run across this and how can we solve this?

      Thanks, In advance, for your prompt assistance!
      Stan

        • 1. Re: Help needed to access Remote database
          Markus Schneider

          what happens after the 'OK'-click? Does FileMaker open the database or quit?

          - Are there any scripts running on first windiw open?

          - Any restrictions on the network/firewall?

          - the files are working on the hostacomputer?

          • 2. Re: Help needed to access Remote database
            sstramel

            Thanks, Markus, for your questions...

             

            No there are no scripts running on First Window Open on any of the databases.

            No restrictions... Firewall is on and setup the same on all PCs and managed by Group Policy.

            We can work on the Host just fine and on a Remote PC of the main user of FMP.

             

            We recently moved the databases off of the Admin's PC and over to a dedicated PC that only has FMP running on it and no one will normally works on it unless workload dictates it.

            • 3. Re: Help needed to access Remote database
              Benjamin Fehr

              How are the privileges set for 'Sharing'?

               

              On the Host-Computer, select

               

              Menue

              File

                   Sharing

                        Share with FileMaker Clients

               

               

              Network Sharing: • On

              Network access to file …

               

              Bildschirmfoto 2016-05-02 um 19.01.59.png

              • 4. Re: Help needed to access Remote database
                sstramel

                Yes, Benjamin, exactly like the picture you attached.  We setup each new user with a blank password and set them to require them to change their password the next time they login but we don't even get to a login.  As stated to Markus, we can login from another PC and the Host PC.

                 

                Capture.PNG

                • 5. Re: Help needed to access Remote database
                  Benjamin Fehr

                  are the access privileges set equally also for files

                  Foreign Subscribers

                  Foreign Office list

                  U.S. Office

                  ?

                   

                  If one of the client computers is with FMP Advanced, start Script Debugger first before open remote in order to analyze the start script to find steps that might lead to a dead end.

                   

                  Check also Menu

                       File

                            File Options

                   

                  Options

                  Open

                  • Log in using: …

                  • Switch to Layout: …

                   

                  Script Triggers

                  • OnFirstWindowOpen

                  • 6. Re: Help needed to access Remote database
                    sstramel

                    Thanks, Benjamin.  All 4 databases are setup exactly the same.

                     

                    None of our licenses are FMP Advanced.

                     

                    On the Host PC, here is what the Options Script Triggers are set to...

                    Capture1.PNG

                    Capture2.PNG

                    • 7. Re: Help needed to access Remote database
                      Benjamin Fehr

                      well, better play it save:

                      What is the "Main-Layout" where the user should be led to when starting up?

                       

                      Don't leave the option for

                      Open

                           [X] Switch to layout: [MyStartLayout]

                       

                      unspecified!

                      Just assign the layout you want to appear after start to this option.

                      This is a general recommendation I would see for every FM-Solutions.

                      • 8. Re: Help needed to access Remote database
                        sstramel

                        OK... changed the Switch to Layout: Subscriptions  per your suggestion on all 4 databases.  Still shows a blank message box when OPEN REMOTE from Host Tab on the PC.

                         

                        Capture.PNG

                        • 9. Re: Help needed to access Remote database
                          patricia

                          How many people are using these databases? Does the new computer have the same amount of RAM as you used previously.

                          You mentioned the remote user "the main FileMaker user " and this work. what is different about this set up?

                          What version were you using before the move?

                           

                          patricia

                          • 10. Re: Help needed to access Remote database
                            Benjamin Fehr

                            it's strange anyway.

                            This looks like a Error Message with a missing language library.

                            - what happens after you click [OK] in the dialog window?

                            - If you open any local file or create a new FM-file with this computer, does FMPro behave as expected?

                            Though this tests should proof if FMPro is installed correctly.

                             

                            Could it be that you've installed one of the FMP with same License key?

                            If identical FM-Keys meet in a FM_Network, the second client will get a error message indicating a "License conflict" and shutting down.

                             

                            You can

                            - open FMP on all computers without open any files

                            - goto Menu

                                 FileMaker Pro

                                      About FileMaker Pro …

                            - click on [Info] to see the license keys.

                            - now compare if some have identical keys

                             

                            License.png

                            • 11. Re: Help needed to access Remote database
                              sstramel

                              Thanks, Patricia, for your reply.

                               

                              Both computers are the same.  We were using FMP 14.   Originally, we had one PC that ran the process and it was installed locally but just switched over to having a dedicated PC that does Hosting FMP only.  Now, the one that the databases originally were on is the now opening the databases as OPEN REMOTE and works just fine.  This other PC is a new install of FMP and has never run FMP before we installed it and now trying to get it to OPEN REMOTE access to the databases.

                              • 12. Re: Help needed to access Remote database
                                sstramel

                                Thanks, Benjamin.

                                 

                                When we click the OK button, the message box goes away.

                                 

                                There is not local database on that PC but when we open the one that came with FMP (FMP - Getting Started.FMP12) it opens it just fine. 

                                 

                                We have 3 licenses that are in use.  One HOST PC and 2 REMOTE PCs.  I checked and all 3 have different license keys.

                                • 13. Re: Help needed to access Remote database
                                  Benjamin Fehr

                                  I'm running out of ideas. Let's try this 'Genie in a Bottle' Trick:

                                  TSGal

                                   

                                   

                                   

                                  PS: maybe a start script 'OnFirstWindowOpen' with script steps

                                  - go to Layout [MyStartLayout]

                                  - Adjust Window [Resize to Fit]

                                  could be another attempt

                                  • 14. Re: Help needed to access Remote database
                                    sstramel

                                    Thanks, Benjamin... yes, this is frustrating.

                                     

                                    I created a script to resize the window per your request and set it to run at startup of a database.  When opened that database, I got the blank message box again.

                                    1 2 Previous Next