Act! by Sage 10.0 Database Files via Network Attached Storage (NAS)

Posted on 2009-12-17
Medium Priority
Last Modified: 2013-11-24
I am using Act! 10.0 (2008) in a small office where they have limited resources. They have a NAS (network attached storage) Linux Samba File Server where I have created a share with guest access only. I intend to store the files there so three (3) client workstations can access the database via the Samba network share.

I have run into a limitation after contacting Sage Support: apparently the host has to have the Act! 10.0 program - including SQL - installed to be able to share it and successfully use it.

I know there are alternative file sharing methods - DFS, Mapped Drives, etc - and I would like to know if there's a "hack" or alternative workaround to connecting to the database files so I do not have to install Act! on the NAS device, which is impossible anyways, since WINE does not support Act! and I don't not have the processing and memory available to handle it.
Question by:ericbechtel
  • 2
LVL 30

Accepted Solution

Mike Lazarus earned 2000 total points
ID: 26072188

SQL is a Client/Server app and you must have the database on a local drive to a copy of ACT! with SQL.

With only 3 users, you could run the database from one of their workstations.

For more info, see: http://blog.glcomputing.com.au/2009/02/sharing-act-network-or-sync.html

BTW: For future reference, there is an ACT! Zone - http://www.experts-exchange.com/Database/Contact_Management/ACT/

Expert Comment

ID: 35199196
Has anything new developed here?  I have a Buffalo Raid5 NAS device I would like to use with ACT! 2009 11.1.183 on MS Vista.

Everything I read says that a computer+locally installed disk is required, but briefly a tech at Sage ACT! support told me it was possible, but unless I paid for even more support and in addition to the six licenses I already own, they would not even email me a link to a KB entry or customer portal link.

If this is not possible, why technically cant this be done.  Why does it matter if the disk physically resides on the computer vs. a network drive?  When I access the current server computer from a remote machine, isnt it essentially doing the same to the server database?

LVL 30

Expert Comment

by:Mike Lazarus
ID: 35200632
SQL requires the database on a local volume to the application.

It's client/server ... that is, when accessing from a workstation, you're actually just calling the application on the server to make a local access to the database and respond back with the data

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
Article by: evilrix
Looking for a way to avoid searching through large data sets for data that doesn't exist? A Bloom Filter might be what you need. This data structure is a probabilistic filter that allows you to avoid unnecessary searches when you know the data defin…
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question