Community
Showing results for 
Search instead for 
Do you mean 
Reply

This database could not be accessed - help?

Accepted Solution Solved
New Member
Posts: 18
Country: USA
Accepted Solution

This database could not be accessed - help?

[ Edited ]

The database   ______ could not be accessed. In order to

access this database, check your network connection and verify that your database server is available.

 

I HATE that message...it usually is precursor to tears and headbanging.

 

 

I have a database on an external drive that i haven't opened in over a year

now i CAN'T open it.

but i desperately need to - no i REALLY need to, this is our nonprofit orgs donation mailing list and now everyone is angry at me for 'losing' it. 

 

I am running  ACT! by Sage 2007 (9.0) Version 9.0.0.175

 

any suggestions?

 

I already TRIED 'deleting' the pad file and trying to open the  ADF file

but all it does is tell me the PAD file aleady exists.

 

I love this software EXCEPT when it comes to it's particular habit of not recognizing its own files.

am i missing something obvious?

 

 

Message Edited by EraserGirl on 12-09-2008 04:43 PM

Accepted Solutions
Solution
Accepted by topic author EraserGirl
‎09-25-2015 03:20 AM
Moderator
Posts: 4,395
Country: USA

Re: This database could not be accessed - help?

You won't be able to access the data unless you can get the database open.

 

Currently, I'm guessing the database is copied to the computer from the external drive.  If not, then you will need to. Once its copied to the computer, follow the steps below:

 

- Go to the Start menu and select Run.  Type in actdiag and click Ok.

- Once ACT! Diagnostics comes up, select Database > Database List.

- Find the database you're trying to open in the list.

- Under the Status column, if the its listed as Suspect, please the follow the KB article below.

      Error" "Cannot Access Specified Database..." and the Database is Listed as SUSPECT in the ACT! Diagn...

- If its not suspect, then right click the database and select Detach.

- Then browse the folder which the database is stored and delete the PAD file.

- Now open ACT! and open the database from with ADF file.

 

View solution in original post


All Replies
Copper Contributor
Posts: 37
Country: USA

Re: This database could not be accessed - help?

try stopping the sql instance and moving the database to the local drive and opening from there. 

Start menu>Run

Type services.msc

Right click on SQL Server (ACT7) and choose Stop

Move the database .ADF, .ALF and the database name-database files folder to your local drive or a shared folder on your server that your workstation is mapped to.

Go back to the services window and right click on SQL Server (ACT7) and choose Start

Open your database by double clicking on the .ADF file

New Member
Posts: 18
Country: USA

Re: This database could not be accessed - help?

what is that supposed to do?

because the results were exactly the same..

it starts it verify the database and then a notice pops up and tells me that the database already exists.

 

should i delete something else?

New Member
Posts: 18
Country: USA

Re: This database could not be accessed - help?

so i moved the databse files folder, the ADF and the ALF to the harddrive with the other operational .pad files.

 

any ideas what i should try next?

Copper Elite Contributor
Posts: 108
Country: United States

Re: This database could not be accessed - help?

Rename the pad file for the database you want to open to something else.  Then either double click on the .ADF file or go into ACT and do a file open and change the files of type from pad to adf.  If you get the error message again that you got initially go back into services.msc and make sure that SQL was restarted and running.  PAD files are basically like shortcut files that point to a database location.  Opening up an ADF file with ACT or double clicking on it will generate a new PAD file with its new location.   

 

The other thing is that each database name that SQL manages must be unique.  Are both your database names the same or different?

 

 

New Member
Posts: 18
Country: USA

Re: This database could not be accessed - help?

 


act_enthusiast wrote:

Rename the pad file for the database you want to open to something else.  Then either double click on the .ADF file or go into ACT and do a file open and change the files of type from pad to adf.  If you get the error message again that you got initially go back into services.msc and make sure that SQL was restarted and running.  PAD files are basically like shortcut files that point to a database location.  Opening up an ADF file with ACT or double clicking on it will generate a new PAD file with its new location.   

 

now i have 'error in accessing or processing a PAD file.'

 

 

The other thing is that each database name that SQL manages must be unique.  Are both your database names the same or different?

 

 


 

 

yes all my databases have different names.

 

 

how can i open this database?  does the data exist in a raw form that i can access?

i just need the data

Solution
Accepted by topic author EraserGirl
‎09-25-2015 03:20 AM
Moderator
Posts: 4,395
Country: USA

Re: This database could not be accessed - help?

You won't be able to access the data unless you can get the database open.

 

Currently, I'm guessing the database is copied to the computer from the external drive.  If not, then you will need to. Once its copied to the computer, follow the steps below:

 

- Go to the Start menu and select Run.  Type in actdiag and click Ok.

- Once ACT! Diagnostics comes up, select Database > Database List.

- Find the database you're trying to open in the list.

- Under the Status column, if the its listed as Suspect, please the follow the KB article below.

      Error" "Cannot Access Specified Database..." and the Database is Listed as SUSPECT in the ACT! Diagn...

- If its not suspect, then right click the database and select Detach.

- Then browse the folder which the database is stored and delete the PAD file.

- Now open ACT! and open the database from with ADF file.

 

New Member
Posts: 18
Country: USA

Re: This database could not be accessed - help?

thank you

this seemed to work, it finally let me open the file.

I didn't know about the Diagnostics panel...that helped tremendously.

 

unfortunately someone has changed the database and it no longer contains what i need.

so i am still in the deepest trouble....but we did solve the mystery of the the unaccessible database.

 

i thank all of you who tried.

 

Copper Contributor
Posts: 25
Country: United States

Re: This database could not be accessed - help?

I am having the same issue.  When I do the actdiag, the status is "RECOV".  It doesn't allow me to detach it. Any suggestions?
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: This database could not be accessed - help?

vPSI:

For the issue you are experiencing, please see the following Knowledgebase article:

 

Error: "Cannot Access Specified Database..." and the Database is Listed as SUSPECT in the ACT! Diagn...

 

This article applies to both SUSPECT and RECOVERING databases

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.