Export view result using transferdatabase

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.md b" _
, 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,
JerryJer (jerry.w.black@.saic.com) writes:
> 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.md b" _
> , 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?

The one idea I get is that you should probably post to
comp.databases.ms-access, or some other Access forum, where people
may know Access better than in this forum.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||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.googlegr oups.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.md b" _
> , 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