Hi everyone,

I have a password protected Access db, where I have reports.

I use this code, to preview the report.

Dim axs as New Access.Application
axs.OpencurrentDatabase("Path")
axs.Docmd.OpenReport "ReportName"
Set axs = Nothing

A small dialog box pops up, asking for the database password.

How can I provide the password in the code, so that the user need not enter it.

Please help.

Thank you.