Community
Showing results for 
Search instead for 
Do you mean 
Reply

Cannot open local database HELP!

Highlighted
New Member
Posts: 3
Country: USA

Re: Cannot open local database HELP!

This same problem happened to me.  Windows 10 upgrade made opening database impossible.  I did not set up a password as I'm the only one on this box.  I deleted the .pad file, but .adf would not open.  Stuck

Highlighted
Administrator
Posts: 4,041
Country: United_Kingdom

Re: Cannot open local database HELP!

Hi Kdasilva,

 

Please Could you try closing Act, then download and run the version of ActDiag I have attached to this post, then click on Tools > Attach Act! Database > Missing Log File. Browse to the .ADF file of the database you're trying to access, and click OK.

Do you get any errors after clicking OK?

Does the database attach?

Are you able to access the database in Act?

Highlighted
New Member
Posts: 3
Country: USA

Re: Cannot open local database HELP!

The whole problem was with the Windows 10 update send down from Microsoft.  I deleted the update, and ACT started fine.  I reinstalled the update, and then ACT started fine again.  Thanks a lot Microsoft for screwing up my box, again!

Highlighted
New Member
Posts: 12
Country: USA

Re: Cannot open local database HELP!

I get an in use error
Highlighted
New Member
Posts: 12
Country: USA

Re: Cannot open local database HELP!

I am not sure if this has anything to do with it. SQL server agent will not start.
Highlighted
Administrator
Posts: 4,041
Country: United_Kingdom

Re: Cannot open local database HELP!

[ Edited ]

You can safely ignore the Server Agent.

 

A few other suggestions:

 

Try closing Act, and restarting the SQL Server (ACT7) service from services.msc, then run ActDiag as admin and try the attach with missing log file method again.

 

If this is not successful in attaching the DB, then I would guess that this might be a .NET issue. I would suggest uninstalling and reinstalling .NET.

Highlighted
Administrator
Posts: 4,041
Country: United_Kingdom

Re: Cannot open local database HELP!

Please ignore the suggestion to reinstall .NET, I got my solutions mixed up. This is not a .NET issue.
Highlighted
New Member
Posts: 12
Country: USA

Re: Cannot open local database HELP!

OK - good I didn't understand that anyway Smiley Happy

 

The other suggestion did not work.  I still got the in use error.

Highlighted
Administrator
Posts: 4,041
Country: United_Kingdom

Re: Cannot open local database HELP!

Would you be able to Install Act on a different PC and try the restore/attach methods with the database?
I'm not sure what could be causing the 'in use' error in this case.
Highlighted
New Member
Posts: 12
Country: USA

Re: Cannot open local database HELP!

Yes - we are trying that out as well.