TransferDatabase Action

  • Thread starter Thread starter Sherri Lock
  • Start date Start date
S

Sherri Lock

Is there any limit on how many objects the
TransferDatabase Action can handle? I am trying to
import more than 700 reports from one database to
another. The docmd.TransferDatabase run fine with the
first 5 reports. On the 6th report, it gave me an error
message stating: An expression you entered is the wrong
data type for one of the arugments. Does anyone know
why? Thanks a lot
 
Sherri,

Forgive me if I am misinterpreting your question completely ... But, if
this is a one-shot import (as opposed to a recurring process), why are you
using TransferDatabase instead of opening the database which will receive
the reports and using File|Get External Data|Import?
 
Back
Top