transferdatabase where source is a sql server view

[Guest]

I am getting an error when I try to use the transferdatabase command in VBA
in an Access 2002 .adp file. It states that it "can't find the object
vwview". My syntax is as follows:

docmd.transferdatabase acexport, "dbase IV", "c:\folder", actable, "vwview",
"outputfile.dbf", false

I have tried acquery, and acserverview with no luck either.
I would appreciate help with this.
Thanks,
Doug

 

[Stefan Hoffmann]

hi Doug,

I am getting an error when I try to use the transferdatabase command in VBA
in an Access 2002 .adp file. It states that it "can't find the object
vwview". My syntax is as follows:
docmd.transferdatabase acexport, "dbase IV", "c:\folder", actable, "vwview",
"outputfile.dbf", false

I'm not sure if TransferDatabase is really working in .adps, but try
using the full qualified name of your view using SQL Server syntax:

user.object

docmd.transferdatabase acexport, "dbase IV", "c:\folder", _
actable, _
"dbo.vwview", _
"outputfile.dbf", false


mfG
--> stefan <--