03-06-2010 06:03 AM
Here i am again, it seems every year or so, ACT! 2007 locks me out of my database.
each time i come here for help trying to recover my database and each time i swear will be the last time i entrust my data to ACT
this is the third time
it won't let me open my database it asks for a password and then says it cannot be accessed
i don't remember creating a password, if i had i would have made a note where i keep such things.
(i hide passwords in .txt files in the folder with the .exe files)
is there anyway i can recover my database or open a backup version?
03-06-2010 08:00 AM
03-06-2010 11:40 AM
The 'devil is in the detail' as they say.... what exactly does the error message say?
I'm assuming that the error message is as follows:
"The database <Database name> 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..."
Is the database installed locally on your PC? If so, use ACTDIAG (start, run, actdiag) to locate your databse in the database list and right click on the database name and select 'detach database'.
Once you have done this, browse to the database 'PAD' file (that is used to open the database) and delete it. Next, re-open ACT, click File, Open and browse to the database folder. hange the 'files of type' drop-down to 'ADF' and select the database name.adf file. Opening the database in this way will re-attach it to SQL (might take a few moments), and this may resolve the problem.
Final step - consider upgrading to ACT! 2010 which is more stable, reliable, feature rich, flexible and compatible with other things than ACT! 2007.
03-06-2010 12:09 PM
cannot connect to SQL Server Instance.
why does this sort of thing happen?
nothing changed with my system since the last time i opened this database.
it is still in the same place it has always been.
03-06-2010 12:17 PM
Sorry but you're not providing nearly enough information. What do you mean "cannot connect to SQL Server Instance". Is this a complete error message and what exactly are you doing to trigger this?
Can I suggest that you take a look at this: What you should add to any support post. It may help you get faster, better results when using the community forums.
03-06-2010 12:49 PM
03-06-2010 01:36 PM