Hi All,

I am not able to understand how to use docmd.transferDatabace in VB6.0 application.

It is working fine if i am using this with Ms access macros.

DoCmd.TransferDatabase acExport, "Microsoft Access", strFile, acTable, strTable, strTable

when I tried to use the same in an VB6.0 application it gives error like this operation requires an open connection.

Please help me

Surjit

What library do you have added in your references to get access to a “DoCmd” class?
I opened a VB project to look into your question, and there is no "DoCmd" class available.
I tried adding DAO and Jet, but neither had that class in them.

    Dim acApp As Access.Application
    Set acApp = New Access.Application
    acApp.OpenCurrentDatabase MDBFile
    ....
    acApp.DoCmd.TransferDatabase acExport.....
    ....

you can use 'DoCmd.TransferDatabase' in Ms access macros,because it's just embed in Access application,but to do this in VB,you will have to build an application in advance.