Thank you Daniel, I think I'll stick to "some People" except were it is really necessairy to use nullvalues! /R

I wounder how null values from a database can be handled in VB 6/ADO. Is it possible to pass a null value from a recordset to a VB parameter? When I try to pass a null value from a recordset to a VB parameter, it fails and the function is stopped. The parameter types are integer (mapping between datatypes is correct). Am I having a wrong (database-) perspective and try to handle null values in a way that you are not supposed to? Any enlightning response is welcomed!

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?

Is there any other easy way to import a diagram to an SQL-server 2000 DB than doing a restore of a backup? (Do not want to do a restore...)

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?

Hi! I use the Datetime dataype in SQL-Server 2000 to store date and time eg "2002-09-04 09:18:20". When I insert data in through VB6.0 and ADO 2.6 i set the in-parameter to an adDBTime and it seems to work fine. Could there be problems in the future and/or is there a better datatype in ADO for this case?

Nick parker's code works perfectly! Thank you all! /Rulle

What's the function to get the local computer name in VB6? Have a good one!