I’m lloking for a way to transfer a query from one .mdb to another (Using vb6). I can transfer Tables using ADOX.Tales and ADOX.Catelog …… There is a way to transfer Views using <>.Views.Append “”,Cmd .. But how can i pick the sql statement from the source View … Any body know the answer ????