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("P2","c:\mssql7\data\p2.mdf"<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.