Password required to export Report

G

Guest

Hi,

I am trying to export a Access Report to another Access
database. I protect the original database with a password.
While I have no problem exporting tables from the original
database to another database, it is not possible for me to
do so for the Report without providing the password first.

The following is the error I get:

Run-time error '2017':

This Visual Basic for Applications Project has been
protected with a password. You must supply the password in
the Visual Basic Editor before you can perform this
operation.

I use the TransferDatabase function.

reportName = "Rpt"
DoCmd.TransferDatabase acExport, "Microsoft Access",
sFile, acReport, reportName, reportName

Would appreciate any help. Thanks.

Tan
 
Top