Community
Showing results for 
Search instead for 
Do you mean 
Reply

Cannot open local database HELP!

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

Administrator
Posts: 2,800
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?

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!

New Member
Posts: 12
Country: USA

Re: Cannot open local database HELP!

I get an in use error
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.
Administrator
Posts: 2,800
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.

Administrator
Posts: 2,800
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.
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.

Administrator
Posts: 2,800
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.
New Member
Posts: 12
Country: USA

Re: Cannot open local database HELP!

Yes - we are trying that out as well.