Web Development

Ask something
Question Locked

Transfer Access View/Query to another *.mdb

0 helpful
3 replies

by uditha

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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 ????

3 replies

by teebes2004

Using DAO you could set a QueryDef object using the name of the query on the source database. The SQL property contains the SQL string. Create another QueryDef object with the name of the query on the target database, set the SQL property and append this QueryDef object to the target database object's QueryDefs collection.

I hope this helps. I know this works as I have done this before, though I may be bit hazy on the the terminology details as it has been a while. :)

by jerry~beans&bytes

if you need the 2nd database to update automatically, yeah, use the code.

if it's just a one-shot, what i usually do (i.e. to move an SQL from dev to prod) is open the query in Edit mode, SQL View and simply copy the text, then go to the 2nd mdb, open the query and paste it in.

no muss, no fuss, and it gives me one more look at the code, just in case.

This discussion is closed to new replies.