10-06-2008 01:56 PM
So far I have not been able to get remote databases sync to work so I just tried connecting across my 2 node network to a database on the 2nd machine - no luck there either. This is with or without firewalls.
Everything else works across both machines. Files can be read and written across both machines without a problem on any drive and in any directory. UAC is off on both. I am sure it is a Vista problem or a SQL server problem. Under Mcafee SQL has full permissions. I have treid both local and network logon on SQL.
10-10-2008 12:25 PM
Vista can be weird at times. If most cases, the Windows firewall has to be enabled and you will need to add SQL and ACT! exclusions. Follow the knowledge base articles below.
10-13-2008 05:11 AM
10-15-2008 11:23 AM
10-15-2008 11:41 AM
10-16-2008 08:31 AM
Mike I get an error to say that the file is not accessible "You do not have permission to open this file" all the folders have full access permissions and I have tried putting sharing permissions on the PAD file also. If I extend the permissions to full access across the whole user directory then Act on the home machine cannot open the file either and I have uninstall and re-install Act to repair this.
BCM shares and syncs without a problem which I isntalled just to test things out.
Cannot get network sync to work either. Both Sharing and sync worked fine on earlier versions on XP. I tried installing XP on both machines as an alternative boot but there are not the drivers available to make this work. It is Vista that is the problem but Sage need to provide a full setup instruction set.
I think my long term strategy is going to be MAC at this rate.
10-16-2008 09:54 AM
Is that the exact error?
Is the PAD file on the server machine or the local machine?
Open the PAD file in notespad and post the contents
10-16-2008 01:03 PM
10-18-2008 04:16 PM
10-19-2008 04:13 PM
PAD File reads
<?xml version="1.0" standalone="no"?>
<!--This file represents a Pointer to an Act Database or [PAD]-->
<ACTDatabase name="ActContacts" host="HOMEOFFICE" location="C:\Users\Patrick\Documents\ACT\ACT For Windows 11\Databases\ActContacts.ADF" type="Sql" />