Transfer acccess object to another dbase

[mybers]

Hello guys,


I have a button on the form "PROCESS" where If clicked it will run an SQl (make-table qry) and Im hoping if the made table can be transfer/send out to another database file..can this be done automatically or be included in 1 process button...?


thanks

mybers

 

[PHV]

Take a look at the DoCmd.TransferDatabase method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244