Posted by serge on 06/07/05 03:59

See if specifying "acQuery" instead of "acTable" helps.
If not try posting this on comp.databases.ms-access



"Jer" <jerry.w.black@saic.com> wrote in message
news:1118070165.662857.296420@z14g2000cwz.googlegroups.com...
> I am trying to export the results of a view from an .adp to an .mdb
> using TransferDatabase. The code I am using is
> DoCmd.TransferDatabase acExport, "Microsoft Access", _
> "C:\___work\WayAhead\Implementation\XTRA_Samples.mdb" _
> , acTable, "x_loe_vw", "LOE_tbl"
>
> When I run this I get an error that states
> " can't find the object 'x_loe_vw'".
> Yet it is defined as a view.
>
> Any ideas?
> Thanks,
> Jerry
>

• Next in forum: Re: UPDATE/INSERT to make One-to-Many table become One-to-One
• Prev in forum: Re: Scheduled jobs
• Thread view: Re: Export view result using transferdatabase

[Reply to this message]