Hi, Has anyone ever been able to get the samples from Microsoft (101 VB samples) to work? I wanted to try the "CreatingMasterDetails" and this is what i get from the start: Invalid column name 'DepartmentID'. Invalid column name 'BaseRate'. PLUS.... My AdventureWorks database is corrupt!! No way to open it anymore; it has blown up to about twice the original size; sqlserver (sqlserverExpress2005) refuse to detach with the comment "Cannot find adventureworks.mdf"; there are now 3 log files; no more tables in the database are accessible; Deinstalling the adventureworks database from within add/remove programs is impossible: "File not found" !!?? The original conn.string from MS: Data Source=.\SQLEXPRESS;AttachDbFilename=\AdventureWorks_Data.mdf;Integrated Security=True;User Instance=True After brute force in removing and reinstalling the dB i changed the conn.string to: Data Source=.\sqlexpress;Initial Catalog=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks;Integrated Security=True and this time the database remains intact but the runtime error about the coluimns remain I tried with some other (disposable :-)) mdf files and it seems that when selecting "Microsoft SQL Server Database File (SqlClient)" as source this corruption ALWAYS happens When selecting "Microsoft SQL Server (SqlClient)" everything seems to work ok Any ideas somebody? Config : VS 2005 Pro Sqlserver Express 2005 Framework 1.0, 1.1, 2.0 Thanks in advance for suggestions Jerome
