Rulle wrote: I wounder how null values from a database can be handled in VB 6/ADO You can check the value of something being returned from the recordset with isnull(adors("someField")). :) Nick Parker **The goal of Computer Science is to build something that will last at least until we've finished building it. - Unknown **

Hmm I've tried both examples now and they all resulted in that a copy was created of an already existing diagram with exactly the same name(!). When I deleted one of the diagrams, SQL Enterprise Manager crashed every time I tried to look at a diagram... insert into Example..dtproperties (objectid, value, lvalue, version, property) select objectid, value, lvalue, version, property from Northwind..dtproperties where objectid = (select objectid from dtproperties where value = 'Relationships') You have to add "Northwind.." in the last statement. I don't see how to transfer diagrams from different servers, only between databases on the same server. Have I missed something?

I found a nice matrix over datatypemappings SQL-server 2000 <> ADO 2.6 at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adosql/adoprg02\_294j.asp Refering to the matrix, varchar should be mapped to adChar, but adVarchar seems more logic to me. Is it an printerror?

No Problem, you should consider becoming a member. :) Nick Parker