09-26-2012 06:21 PM
We've been running Act 2011 Pro on a small office network, with everyone able to access the database. Our old fileserver (Windows XP) recently crashed and has been replaced with a new machine running Windows 7 Home Premium.
The database file is intact, and can be opened on the server, and the database is shared, but we're unable to access it from any of the client computers. All users can read and write on the drive where the Act database is located. I've turned off Windows Firewall, with the same result, so it doesn't appear to be a firewall problem.
Does anyone have any suggestions regarding undocumented Act tweak that I may need to do, or quirks of sharing from Win 7 Home? (Other clients on the network are running either XP or Win 7).
Thanks in advance,
09-28-2012 01:54 PM
Welcome to the Sage ACT! Online Community!
Here is an article with the most common causes for not being able to access a shared database: KB Article 19640
09-28-2012 08:17 PM
You might also need to make some changes to your Windows Firewall. Check out KB article19420 for instructions on how to update it.
10-01-2012 01:09 PM
Thanks for the suggestion re: Windows Firewall.
I have (for the moment) turned the firewall off completely, and now get the following result:
I can now "see" the database, get a login prompt, but upon logging in, I get the following error message:
"Cannot find supplemental files folder SALES1-database files in this location <SERVER_NAME>.
This could be problem with the share, or the folder may not exist.
Please contact the administrator of the database."
However, the folder in question is there, in the same location as the database file itself, and appears to be shared properly.
Any further suggestions at this point?
Thanks in advance,
10-01-2012 02:13 PM
10-01-2012 08:50 PM
Turn off sharing and then turn it back on again in Tools | Maintenance inside ACT!.
10-02-2012 05:39 AM
Here is an article addressing the 'Supplemental files folder' error: KB Article 14101
Look at the section specific to opening a shared database.
10-02-2012 08:09 AM
10-02-2012 08:49 AM
You need to be logged in as an administrator to share a database.
10-02-2012 08:57 AM