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

Posted on 2009-12-17
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
    LVL 30

    Accepted Solution


    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:

    BTW: For future reference, there is an ACT! Zone -

    Expert Comment

    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
    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
    "Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
    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…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now