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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Report with Graph to Excel error 2495 1
Get External Data wants VBA Password 2
Password trouble in exporting dadta to Word 4
Import from Protected Excel File 0
Exporting from MS Access to a protected spreadsheet 1
Importing into protected database 2
Can I automate exporting an Access report as a .rtf file? 1
export all reports 3

Top