tag:blogger.com,1999:blog-7176045.post-16855891514782887332007-08-02T00:22:00.000+04:002007-08-02T00:22:00.000+04:002007-08-02T00:22:00.000+04:00I had the same problem where transferdatabase did ...I had the same problem where transferdatabase did not work for the "CurrentProject" (forms, reports etc.) but worked for "CurrentData" (tables, queries etc.)<BR/><BR/>If this happens between two MS Access databases, try the same export/import from the MS Access application (File->Get External Data->Import), it might give you some insight as to why the code is not working.<BR/><BR/>In my case, the source database was protected with a password and once I removed it (in the VBA window, Tools -> (project) Properties -> Protection tab) the transferdatabse code worked for forms, reports etc.Anonymousnoreply@blogger.com