Trying to access restricted database using GetDatabase method

I created a form for managers to lookup employee data using LotusScript in R4, but it no longer works in R6.5.1. The code resides in a form that a manager logs into and pulls data from another Notes database that no one has access to.

Set EmpMastFile = NotesSession.GetDatabase(“SERVERNAME”, “dept\IS\file.nsf”)

Now an error message appears telling the user that they do not have access to this database, which is correct, because it contains HR information on all employees. Any ideas how to access the data without changing access to this database?

Subject: Trying to access restricted database using GetDatabase method

If the data in the high-security database can be divided into stuff the managers can see and stuff they can’t, you’ve got some options. For example, you can break the information out into two sets of documents, the more sensitive of which is protected by Readers fields, or you could have a scheduled agent periodically copying the less sensitive information to a less secure database.