Community
Showing results for 
Search instead for 
Do you mean 
Reply

Database won't open

Accepted Solution Solved
Copper Contributor
Posts: 64
Country: USA
Accepted Solution

Database won't open

Windows 10  Act Pro 21.0.295.0

 

My F:/ data drive went bad. This included my two ACT databases.  I replaced the drive, named the new drive to the same drive letter, and restored from the backup drive.  The new drive and data seem to be fine and other things are working.

 

But neither of my ACT databases will open, although one of them opened once yesterday since the restore.  The message is:

 

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

I have temporarily inactivated my firewall to no effect.

 

I suspect they are not opening in SQL, though I don't know how to check that.  I have included a screenshot of services.msc below.

Any help much appreciated.

 

Thanks.


Accepted Solutions
Highlighted
Solution
Accepted by topic author stillstonevisions
‎02-19-2019 06:39 AM
Copper Contributor
Posts: 64
Country: USA

Re: Database won't open

I tried RE-restoring the two databases from my backup, and this time they both open.  Apparently the problem was somehow in the restore process.

 

Thanks for offering help.

View solution in original post


All Replies
Silver Contributor
Posts: 1,832
Country: United_Kingdom

Re: Database won't open

Is the option to create a new database visible or greyed out? If visible SQL is running.

 

 

Rename the database .pad file to .old

 

Now open the database use the . ADF file

 

ACT will recreate a new .pad file with the correct information and the database should open.

Copper Contributor
Posts: 64
Country: USA

Re: Database won't open

The "Create New Database" is visible and working.

 

I renamed the .pad file and opened the .adf file. Unfortunately, I got exactly the same message as above.

 

A new .pad file was created.

 

 

Highlighted
Solution
Accepted by topic author stillstonevisions
‎02-19-2019 06:39 AM
Copper Contributor
Posts: 64
Country: USA

Re: Database won't open

I tried RE-restoring the two databases from my backup, and this time they both open.  Apparently the problem was somehow in the restore process.

 

Thanks for offering help.

Silver Contributor
Posts: 1,832
Country: United_Kingdom

Re: Database won't open

Glad its sorted