Sharing Act DB with Domain and Non-Domain Machines

[nicktod]

Hello All...

OK.. I read a note almost like this BUT.. here's my issue..

Sage ACT! Pro 2011 Version 13.1.111.0, Hotfix 1

I have a shared DB on a Windows XP Pro PC connected to a domain.

I have several users that have domain accounts and have permission to connect and have been connecting fine.

We have two NON-domain machines attempting to 

After reading a couple of notes, I still cannot figure this out although I think I'm pretty close..

Here's the unedited PAD file that works for the domain-based clients.

_______________________________________________________________

<?xml version="1.0" standalone="no"?>
<!DOCTYPE ACTDatabasePADFile>
<!--This file represents a Pointer to an Act Database or [PAD]-->
<ACTDatabase name="NGKF_Office_DB" host="PORSPAREWXP-DT" location="C:\Documents and Settings\107473\My Documents\ACT\ACT Data\Databases\NGKF_Office_DB.ADF" type="Sql" />

_______________________________________________________________

I figure I can an edit this to reflect connecting via IP rather than "computer name", but I cannot figure the details out. I have the shared drive mapped on the non-domain system point directly to the folder that had the PAD file (see_mapped_drive).

This is how I'm attempting to edit the PAD file on the non-domain machines.

The question is do I need to edit the "location=...." to match the mapped drive path or does that stay static?

_______________________________________________________________

<?xml version="1.0" standalone="no"?>
<!DOCTYPE ACTDatabasePADFile>
<!--This file represents a Pointer to an Act Database or [PAD]-->
<ACTDatabase name="NGKF_Office_DB" host="\\10.53.168.21" location="C:\Documents and Settings\107473\My Documents\ACT\ACT Data\Databases\NGKF_Office_DB.ADF" type="Sql" />

_______________________________________________________________

Any assistance would really help...

Thanks..

Nick

[Roy_Laudenslager]

How many systems connectiong to the XP machine?

[nicktod]

About six.. just three active users at one time..

The only reason for the machine was to serve up the DB.

There's a copy of office on the machine for minor overflow work.

very basic

[HayesConsulting]

Nick,

You could certainly try the IP address for the HOST instead of the computer name. It would look like this:

<ACTDatabase name="NGKF_Office_DB" host="10.53.168.21" location="C:\Documents and Settings\107473\My Documents\ACT\ACT Data\Databases\NGKF_Office_DB.ADF" type="Sql" />

What error do you get? 

Have you tried turning off the Windows firewall (or other firewalls)?

I'd try opening up the ADF file directly and see what it says