11-22-2019 01:32 PM
I am running Act! Pro Version 21.0.295.0, Update 9
Updated from Office 11 to MS Office 16
I have a private database on my PC only
Windows 7 Operating System
After I installed MS Office 16 I have not been able to open my database. I receive the error accessing database message.
I have tried stopping and restarting SQL with no success.
The following screen shows the 1 database (DeluxSteve) I need to open is not shared, is this my problem?
Thanks for your help!
11-26-2019 03:01 AM
I would use actdiag to check the status of the database as it may be in recovery, if it is then this will help with fixing it. Sometimes after a windows update I've seen it happen but a re-boot or restarting the service normally fixes it.
11-26-2019 03:36 AM - edited 11-26-2019 03:36 AM
What is the actual error message you get when trying to open the database or does it simply not do anything?
Updating the Office suite will have also updated your preferences for office and might mean that when ACT goes to open it is pointed to the linked office that no longer exists. I would delete the ACT preference file and then try opening ACT again.
11-26-2019 06:28 AM
Thanks for the assistance.
When I first open Act, the first shot is the screen I see. The second shot is what happens after I try to open it. I am on a network, but Act is not on the network.
11-26-2019 06:43 AM
The message is a standard one but odd that it comes after the log-on credentials page. I would normally expect to see this when first selecting the database.
Just to see if this is database specific or a problem with the installation what happens when you try and open the Demo 2019 database. (User name will be Chris Huffman with no password needed.)
11-26-2019 07:53 AM
I can open the Demo 2019 database with no problem, however when the database is open I checked SQL Configuration and Server Agent is still not running. Is that ok?
11-26-2019 08:06 AM
The SQL agent is not needed to run
Click the windows key, type in actdiag then click on the application, on the menu at the top click databases -> database details list and in the list look at what the status is.
11-26-2019 09:08 AM
the error looks as though the act7 instance of SQL is having an issue, you could try running the ResetSQL.bat file from here https://help.act.com/hc/en-us/articles/360024250734 and follow the instructions to see if that fixes it.
there is also another KB where if the users are mising from the SQlL instance that act! needs it should create them for you https://help.act.com/hc/en-us/articles/360024421473