Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

cannot reconnect mdf file after MSDE reinstall (I'M IN DEEP TROUBLE)

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I have an access 2000 database with an MSDE back-end.<br><br>After reinstalling MSDE using a different authorisation account, I have began reconnecting the databases to the server by firstly copying the mdf file to the mssql7/data directory, and then calling the attachwithsingle file function. This works file for all the databases except one, the most important. It comes up with the following error:<br><br>Runtime error '-2147220559 (800403b1):<br><br>Microsoft[ODBC SQL Server Driver][SQL Server]Database 'P2' cannot be opened because some of the files could not be activated.<br>Microsoft[ODBC SQL Server Driver][SQL Server]could not open new database 'P2'. CREATE DATABASE is aborted. <br><br>If I click debug after this error, then it breaks on the line:<br><br>svr.attachdbwithsinglefile(&quot;P2&quot;,&quot;c:\mssql7\data\p2.mdf&quot;<br><br>I think I may have messed around with the security settings. I do not know if that has anything to do with it.<br><br>ANY HELP would be greatly appreciated.<br><br>Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top