Opening other application in Read only mode

[Andy Kim]

I am desparate to find out if there is a way to open
another application in read only mode.

I need to run a report from another application that
resides on a network server. The problem is a user who has
only READ access to the folder gets an error while trying
to open the database. Here is the code I am using:

Dim objAccess As Access.Application
Dim dbPath, strWhere, strSQL, strMsg As String
Dim dbs As Database
Dim rst As Recordset

dbPath = "s:\industry_sect\schedule2\revenue\"
dbPath = dbPath & "Online\FundingBuild - Apr03/mdb"

Set objAccess = New Access.Application

objAccess.OpenCurrentDatabase dbPath

Any help would be appreciated,

Andy.