Community
Showing results for 
Search instead for 
Do you mean 
Reply

Error Accessing Database Act! Pro Version 17.1.169.0, Hot Fix 4; Windows 7

Copper Contributor
Posts: 22
Country: Canada

Error Accessing Database Act! Pro Version 17.1.169.0, Hot Fix 4; Windows 7

Hi you guys (and ladies)!

 

I am running Act! Pro Version 17.1.169.0, Hot Fix 4 on Windows 7 Home Premium 64-bit with Bitdefender Total Security 2017.

The database in on my hard drive and not on a server.

 

Every morning, I need to boot and reboot and re-reboot to eventually access my database.

The more reboots, the more paranoia coffee and suspense!

And when it opens, it goes to the Welcome page even though the preferences are set for Contacts to come up.

 

When I click on the Database, there is no Share-UnShare appearing as would be normal.

And then the message ...

 

  • The database could not be accessed.  In order to access this database, check your network connection and verify that your server is available.
  • It may be necessary to disable any firewall software on your computer or on the server.

 

Disabling the Bitdefender firewall and rebooting the computer did not help.

 

Please let me know if you have a solution.

 

With thanks, Alan

 

 

 

 

 

Administrator
Posts: 3,990
Country: United_Kingdom

Re: Error Accessing Database Act! Pro Version 17.1.169.0, Hot Fix 4; Windows 7

Hi Alan,

 

It sounds like the SQL service might not be starting properly, and therefore not allowing Act! to access the database.

 

Please try the steps in this Knowledgebase article to check if the service is running. I'd also suggest trying setting the Startup type of the service in Properties to Automatic (Delayed Start).

Copper Contributor
Posts: 22
Country: Canada

Re: Error Accessing Database Act! Pro Version 17.1.169.0, Hot Fix 4; Windows 7

I had tried this last week.  Didn't work.  This time it worked!  many thanks.  I hope that it holds.  Regards, Alan

Copper Contributor
Posts: 22
Country: Canada

Re: Error Accessing Database Act! Pro Version 17.1.169.0, Hot Fix 4; Windows 7

Hi Gary.

Still no go!

I need to restart SQL (Act7) every time I start the computer.

I'll eventually need (probably) to live the nightmare of reiinstalling Act but I am still trying to avoid it.

Thanks, Alan 

Highlighted
Administrator
Posts: 3,990
Country: United_Kingdom

Re: Error Accessing Database Act! Pro Version 17.1.169.0, Hot Fix 4; Windows 7

Hi Alan,

Did you try changing the startup type of the SQL Server (ACT7) to Delayed Start?

There is another solution for this issue that can be found in the following Knowledgebase article: http://kb.act.com/app/answers/detail/a_id/38362
Copper Contributor
Posts: 22
Country: Canada

Re: Error Accessing Database Act! Pro Version 17.1.169.0, Hot Fix 4; Windows 7

Hi Gary & Rob.

 

 

I tried the .startsql.bat and now Act automatic startup is intermittent.

The shortcut is was the appropriate folder in Program files and also in Programs (64) as well on separate occasions.

Still intermittent at best.

 

We tried!

Thanks for your help.   Alan