Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT Lockout

New Member
Posts: 18
Country: USA

ACT Lockout

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?

 

 

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: ACT Lockout

That sounds like the SQL server in Windows  isn't running.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 18
Country: USA

Re: ACT Lockout

how would i know ? and more to the point how would i fix this?
Copper Elite Contributor
Posts: 118
Country: United_Kingdom

Re: ACT Lockout

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.


Will Ingleby
ACT! Certified Product Specialist

Solutions for Accounting & CRM (UK)

New Member
Posts: 18
Country: USA

Re: ACT Lockout

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.

 

 

Copper Elite Contributor
Posts: 118
Country: United_Kingdom

Re: ACT Lockout

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.


Will Ingleby
ACT! Certified Product Specialist

Solutions for Accounting & CRM (UK)

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: ACT Lockout

Right click on My Computer and select Manage then open services and look for the service SQL Server (ACT7).
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 18
Country: USA

Re: ACT Lockout

i ran ACTDIAG and a small grey box popped up and said exactly that : "cannot connect to SQL Server Instance". 

and that was all that happened.

 

 

does this help? 

 

 

Copper Elite Contributor
Posts: 118
Country: United_Kingdom

Re: ACT Lockout

Keep attempting to run ACTDiag and when the error message appears, click 'No' - this will restart ACTdiag. You might have to do this 3 or 4 times but it will open Actdiag eventually, then follow the instructions provided earlier.

Will Ingleby
ACT! Certified Product Specialist

Solutions for Accounting & CRM (UK)

New Member
Posts: 18
Country: USA

Re: ACT Lockout

the database is labeled SUSPECT, and when I right click the detach option is grayed out.