Transfer database

[samotek]

In the OnOpen event of my form i have the folowing command:
DoCmd.TransferDatabase acImport, "Microsoft Access", CurrentDb.Name, acTable, "orders1", "orders2", False

On opening the form i get the meesage the Transfer database action was cancelled. What is the reason ?

 

[TheAceMan1]

How are ya samotek . . .

The Db you import from or export to, has to be external to the current Db:

[blue]TransferDatabase: You can use the TransferDatabase action to import or export data between the [purple]current Microsoft Access database and another database.[/purple][/blue]

Also for the Database Name:

[blue]The name of the database to import from, export to, or link to. [purple]Include the full path.[/purple] This is a required argument.[/blue]

[blue]Your Thoughts? . . .[/blue]

BTW, put the cursor on the work [blue]TransferDatabase[/blue] and hit F1

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886