Community
Showing results for 
Search instead for 
Do you mean 
Reply

Error Accessing Database

Copper Contributor
Posts: 22
Country: Canada

Error Accessing Database

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

 

 

 

 

 

Copper Super Contributor
Posts: 22
Country: United_Kingdom

Re: Error Accessing Database

Hi again Alan.

 

This error could be one of multiple things so please go through the following article and follow the steps outlined.
It will more thank likely be one of these.

 

http://kb.act.com/app/answers/detail/a_id/19640

 

Thanks

Rob

Robert Hupston
Act! Certified Consultant
Web: http://softext.co.uk
Email: rob@softext.co.uk
Tel: 0121 323 2304
Copper Contributor
Posts: 22
Country: Canada

Re: Error Accessing Database

Thanks Rob.

It was the SQL that was not starting and it was an intermittent issue for  reason beyond me.

Now it works and it seems solid.

Much appreciated, Rob.

Alan  

Copper Contributor
Posts: 22
Country: Canada

Re: Error Accessing Database

Hi Rob.

 

Well, now it is intermittent at best.

Opening my Act database now means restarting the SQL (Act7) each reboot of the computer.

I wonder if there is a way to fix or replace it without reinstalling Act and risking other drama.

When I recently did a reinstall, I got all kinds of pain that the install had with SQL.

 

Any thoughts?  

 

With thanks, Alan

Copper Super Contributor
Posts: 22
Country: United_Kingdom

Re: Error Accessing Database

Morning Alan

 

There is a way to get round this so the SQL (Act7) force starts every time.

 

You possibly have another program that auto loads and is conflicting with this.

 

Please see following article with instructions on setting this up.

 

http://kb.act.com/app/answers/detail/a_id/38362

 

Regards

Robert

 

 

Robert Hupston
Act! Certified Consultant
Web: http://softext.co.uk
Email: rob@softext.co.uk
Tel: 0121 323 2304
Moderator
Posts: 451
Country: United_Kingdom

Re: Error Accessing Database

Hi Alan,

 

I do know of a work around to this issue is having a Batch file that will run in your windows start folders.

I have included the file below as well as instructions

 

Download the StartSQL.bat

Ensure to save the file in a location that you are happy to keep it in and where it will not be deleted.

Right click on the .Bat file and create 2 shortcuts.

On Each shortcut Right click and go to properties

Under the Shortcut Tab - Advanced - Tick Run as administrator

Move a Shortcut to each of the locations below:

Present Logged-on user:

%appdata%\Microsoft\Windows\Start Menu\Programs\Startup

Startup folder for all users:

%programdata%\Microsoft\Windows\Start Menu\Programs\Startup 

Restart your PC and Test.