10-15-2012 09:15 AM
I have screwed up my act2009 database due to a computer crash.
I then got - The database xxxxxxxxxxxx could not be accessed. In order to access this database, check your network connection and verify that your database server is available. It may be necessary to disable any firewall software on your computer or server.
I have tried everything on the sage suppoirt page http://kb.sagesoftwareonline.com/app/answers/detail/a_id/19640/~/error%3A-%22the-database-%26lt%3Bda...
as the darabase was shown as suspect in the actdiag.
However now I cannot recreate database and receive the message below
PLEASE HELP!!! ITS VERY URGENT
10-16-2012 06:23 AM
I suspect that not all of hte database was copied back properly following the computer crash. Do you have a way to go back to the backup or the original drive?
You may consider hiring a consultant to help you make sure. Not doing this correctly could cause a lost of your data.
What I would do would be to go back to the original drive. Look for the ADF, the ALF and hte supplemental files folder for the database and copy them to the "new" system,
Then detach the suspect database via ACT Diag (don't delete the files)
Then reattatch the original database, using file, open, and open the ADT (not the .pad file)
Again, you may want to use a consultant as there are more options and all of them technical.
10-16-2012 06:56 AM - edited 10-16-2012 06:57 AM
Unfortunately, it does look like the database is damaged and will need to be repaired or restored from backup. However, there is one thing you can try:
- Close ACT! and all other running appplications
- Open ACTDiag and detach the database (if attached)
- Browse to the location of the database files and rename the .ALF file for the database (CorporateImageManagement2012.alf) by adding "OLD" to the end of it.
- In ACTDiag, go to Tools > Attach ACT! Database > Missing Log File
- Browse to the .ADF file for your database and attempt to reattach it, then open it
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.