07-02-2009 08:28 AM
Like so many others I am getting the "The database could not be accessed" error. I have read may articles here about how to fix this problem including Article 19640 which has about a dozen suggestions. I have tried it all with no success.
I have 4 to 5 users accessing an Act 2007 database on our our server (running Server 2003) and all are getting the "the database could not be accessed" error. I can run Act on the server and access the database with no problems. Just a reminder that I have tried everything I could find here including checking that Act is setup to share the database, etc.
We have been down for a couple of weeks now we'll have to consider other options if I don't get this fixed very soon.
07-06-2009 02:49 PM
Are the users able to ping the IP address of the server through the DOS command screen?
If so, then try opening the .PAD file for the database and changing the host name to the IP address of the server.
If not, then the issue is communication between the users and the server.
If you change the host name to the IP address in the .PAD you may also want to change the datastore location on the server:
- On the server, make a backup of your database, then close ACT!
- From the Windows Start menu, choose Run and type actdiag
- When ACT! Diagnostics opens, select Databases, then Database List
- Highlight the main database, right-click on it, then select Database Fixes, then Datastore Location
- Verify the path to the database is correct in the top box, then select IP Address and use the same IP address you used in the .PAD file
Note: If all the options are grayed out and you have a red warning that the database is not shared, then the issue is that DB is not properly shared
- Click OK and follow the remaining prompts to complete
Try moving the database to another location, like a new directory on the root of the hard drive. The following Knowledgebas article provides steps to move an ACT! database:
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
07-09-2009 09:00 AM