need to export under dbo.

G

gandalf

is there a way to make sure that

DoCmd.TransferDatabase acExport, "ODBC", fcConnectServer
("tempdb"), acTable, "ListOrders", "[dbo].[ListOrders]",
True

would export to tempdb.dbo.ListOrders under SQLServer
(2000)?
Even if the login is "myuser"?
The table needs to be alterable by myuser

any other suggestions?
 
Top