ADO og sammenkædede tabeller.

any special reason why you need to use ADO?

Ikke specielt.
Jeg har bare fulgt lidt med i spørgsmålene om DAO vs. ADO, og læst mig til at DAO var på vej ud.

It is still used widely in Access and I expect there will go some time before that changes.
Linking tables in code isnt something which is done so often so you may as well keep that part in DAO and concentrate on using ADO for other database tasks.

As far as I know its only in Access where its necessary to link tables in code.

Ok. Hvis du mener DAO holder "længe" endnu, så kører jeg videre med det.
Smider du et svar? Så lukker jeg spørgsmålet.
Tak for hjælpen.

you can also link Access tables WITHOUT DAO or ADO!

DoCmd.TransferDatabase acLink, "Microsoft Access", "C:\test.mdb", acTable, OriginalName(1), NewName

Ganske smart at man selv kan navngive tabellen. Newname
Tak skal du ha.

selv tak