I wish, when i get the result of an SQL-QUery, to find the value of the names of the matching columnnames and insert these in the variable for output. This is instead...

It can be because of the way the link accesses the DB, there can be an translation difference. Perhaps it's because of the uft 8 problem. Microsoft have some difficulties in...

sorry, i don't have been here for some time, have been busy. But have found the solution. i make the joins into entreprise manager and put them into the script....

Tried this, still 0 records.

The line RStr = RStr & CStr (Ors...  was used as a experiment to ensure the data could be used, as they are in many different values,...

Yes, then it's a comment, not an argument, if it's after the " and inside " it doesn't find anything, even i have tried into SQL query analyser and there...

right, this way wasn't good enough, but suddenly i could step by step confirm a new id on the old table, by setting properties right.

Why, i don't know, thought i...

ok, this is done. I succeded into it by step by step. thanks a lot for your help. I now understand much more about this structure.

Now i have to get...

if I try this : 'Multigroove' = Gruppe.navn " it gives 1152 records returned. i'm not sure it's correct, but i cannot find out, because in the lines:

Do While Not (oRs.EOF or...

INSERT INTO [PLVKTSYS].[vktadmin].[Hovedtabel2]([vkt_nr], [billede], [fil1], [fil2], [gruppe], [undergruppe], [ops_overvkt], [ops_undervkt], [anvendelse], [bem_t_anv], [totallaengde], [delinger], [bredde], [hoejde], [naeseRadius], [hornimm], [vinkel], [sporbredde], [forsætn_prof_hoejde], [tegningshenvisning], [placering], [reol], [hylde], [brugesaf], [kunde], [leverandor], [rekvnr_pris], [bem_t_vaerk],...

result of insertion into queryanalyser:

Multiple identity columns specified for table 'hovedtabel'. Only one identity column per table is allowed.

don't understand it, in index/keys there's only one specified? where are the...

This really snap it's own tail! It was the problem from start: i couldn't put new identity column on the table. Gives this: 'hovedtabel'...

i used query analyser for it and it gave the results i wrote before. trying if i can find anything about this, it takes a little without searchpanels! 

tried to delete a row with possible troubles, but get message:

key column information insufficient or incorrect. too many rows were affected by update.

same mesage af if i try to edit...