I have a simple file server application that uses Ms Access and Vb. I have a general password on the database. My reports are in Access. Each time I want to view a report, I set up an application object for Access, then I use the OpenCurrentDatabase method to make the connection, then use the docmd to actually view it. The problem is that I am prompted for a password each time I want to see a report, even though I already was prompted for one when I opened my application. Here's my code:
Set msaccess = New Access.Application
msaccess.OpenCurrentDatabase (" path of database")

msaccess.DoCmd.OpenReport "report name", acViewPreview
DoCmd.Maximize
msaccess.Visible = True

I tried putting the password in the OpenCurrentDatabase statement,but it won't take it. There must be a way to do this because I am looking at the data report designer, and it's really goofy.