Reply to Re: Export view result using transferdatabase

Your name:

Reply:


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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация