08-02-2015 09:33 AM
08-03-2015 09:23 AM
To further clarify, I have already read http://kb.swiftpage.com/app/answers/detail/a_id/30561/kw/port%201434 and as expected, it has no effect. Also, I tried several of the options listed in kb.swiftpage.com/app/answers/detail/a_id/19640/kw/share act database/related/1 and nothing has worked (including changing the .pad file to point to the IP address of the 'server').
Nothing in the above KB articles addresses how opening from the File menu is successful, but not opening ACT (which automatically opens the last database accessed). I have to wait nearly a full minute for the error to occur before I can even attempt to use the File menu to open.
08-03-2015 09:49 AM
This is an odd one but I suspect that if may be corrupted ACT! preferences. I would use ACTDiag to delete the preferences and see if that fixes the problem.
08-03-2015 07:24 PM
There's a lot of custom layouts, preference settings and I'm concerned about wiping them out. Which files are removed? I'm guessing %appdata%\ACT\ACT Data\preferencesBak.xml, but I'm not sure about others. I'm assuming if I delete or rename this file, all ACT settings will revert to defaults(?)
08-03-2015 09:29 PM
Not all, mainly the ones that are listed in Tools | Preferences. In general the things that are there for every user would stay, only the preferences specific to the individual user. The one that is most noticeable is the email setup.
08-05-2015 04:12 PM
I deleted the preferences as you had suggested and I'm still getting the same problem.
Also, not sure if this is related, but Outlook is very slow to load, then eventually prompts with 'ACT address book is not properly configured or the configured database is locked ...' (ACT-Outlook integration). This occurs on every load of Outlook, even when I properly complete the prompts, including password, etc. This also occurs if I disable integration in ACT or even disable the ACT add-ons. There's no escape from this.
08-07-2015 08:35 AM
Can you please try adding the dynamic sql port and ip address to the pad file as outlined below?
Modifying the .PAD File:
08-07-2015 10:46 AM
As I had stated earlier, I had already tried the options shown in the 2 KB articles I referenced. The only thing hadn't yet tried was adding the SQL port # to the IP address. I tried adding the SQL port # of the server like (<ip address.,<sql port # of server>) to the .pad file and not only did it fail once, it even failed when using the File menu. I also tried using the sql port # of the target computer (the one accessing the shared database) and that failed as well.
I was forced to revert back to using either the IP address or computer name of server to at least be able to open the database off of the File menu (although it still fails when opening ACT).