04-21-2008 11:07 AM
I need help. I am trying to share our Act by Sage version 2008 (10). I have had nothing but problems. I called tech support to find out I was 31 days past install and they would only support thru payment. So long story short. I have had database sharing problems since we got our 5 users license. I have searched online and have been able to fix all but one of my problems.
1st error was "The database could not be accessed. In order to accesss......." I believe I was able to fix this thanks to this site which was a 14 page fix. Way too hard to configure. This program should set all the features that it needs during install.
Now to my latest problems. Everything was opeing great then I get this error "Cannot find database supplemental files folder <data name> in this location <sales1>. This could be a problem with the share, or the folder may not exist. Please contact the administrator of your database." Problem is I am the administrator. I have no supplemental files. So how do I fix this.
Any help would appreciated.
04-10-2009 09:16 PM - edited 04-10-2009 09:36 PM
This worked for ACT 2006, when I moved "shared" ACT database from one server to another.
I followed standard procedure for moving the "shared" database (via "Backup" and "Restore as" ) but still had problems. Remote clients would get the error "Cannot find database supplemental files folder". The below procedure fixed it.
Requires a SQL server of the same version as the ACT server instance (SQL 2000 for ACT 2006)
04-10-2009 10:01 PM
Note: After this, do not re-open ACT from the local server. (Only open it from remote clients.)
Opening it locally sometimes "re-breaks" the ACT supplemental files folder database entry. (the below procedure fixes it again.)
03-01-2010 12:36 PM
I am running ACT 11 on a Vista (SP2) machine. Another machine in our office is attached to the ACT database and has worked fine for over a year. All of a sudden last week, I started getting the "supplemental files folder" error as listed above. I believe the night before ACT quit working, Window loaded some updates, so I'm suspecting this may be the cause...hmmmm. I was wondering if anyone can give the steps necessary to unattach and reattach the database to SQL 2005. Any information would be greatly appreciated. Thanks!
03-01-2010 01:30 PM
Try this: open your database on the host machine > go to Tools\Database Maintenance > click on 'Share Database' (this will unshare it). Close Act! > reopen it and go back to Tools\Database Maintenance and click on 'Share Database' (to re-establish the sharing on the folder). Test.
If that does not resolve the issue, visit this link (same as link above): Cannot find database supplemental files folders
01-07-2011 07:47 AM - edited 01-07-2011 07:49 AM
Thank you for this! I just lived through a similar experience. I was migrating from SBS 2003 one one machine to SBS 2008 on a new machine while (and at the same time) converting from ACT 2006 Premium to ACT 2011 Premium. I installed SQL server 2008 but I couldn't attach the database files as you indicated because of a version mismatch so I gave up on that. I did have the SQL management tools installed though so I was able to simply connect to the running ACT SQL Express instance and modify the table directly. My steps to success ultimately were as follows: