Posted by Erland Sommarskog on 06/07/05 02:04

Jer (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.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?

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/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Rows to Column Names
• Prev in forum: Re: Strange Backup Problem!
• Thread view: Re: Export view result using transferdatabase

[Reply to this message]