Wrongly Entered Readers Field in Lotus Notes Document

Mistakenly while updating the document through LotusScript I have appended some value in and item which was basically a notes reader field on the form. Now the problem is that this document has not been accessed by anyone not even the one who created it. What can I do?? Can I retrieve the document and update the reader field?? Is there any method ?? The code for updating the reader field notesitem is attached for reference.
I don't know what went wrong because same code is running perfectly fine in an other database.

Dim s As New NotesSession
	Dim db As NotesDatabase
	Dim docs As NotesDocumentCollection
	Dim n As NotesName
	Dim ws As New NotesUIWorkspace
	Dim nameVar As Variant
	Dim doc As NotesDocument
	Dim item As NotesItem
	Set db = s.Currentdatabase
	Set docs = db.Unprocesseddocuments
	nameVar = ws.Pickliststrings(PICKLIST_NAMES)
	If nameVar(0) = "" Then
		Msgbox "Please select any name to continue",64,db.title
		Exit Sub
		Set n = New NotesName(nameVar(0))		
	End If
	Set doc = docs.Getfirstdocument()
	If doc Is Nothing Then
		Msgbox "No document is selected, Can't proceed",64,db.Title
		Exit Sub
	End If
	If ws.prompt(PROMPT_YESNO,db.Title,"This will change current desk to the selected user in selected document, Do you wish to continue?")Then
		While Not doc Is Nothing			
			doc.CurrentApprover = n.Abbreviated			
			Set item = doc.Getfirstitem("WorkflowReaders")
			If Not item Is Nothing Then
				Call item.Appendtotextlist(n.abbreviated)
			End If
			Set item = doc.Getfirstitem("fl_Readers")
			If Not item Is Nothing Then
				Call item.Appendtotextlist(n.abbreviated)
			End If
			Call doc.Save(True,False)		
			Set doc = docs.Getnextdocument(doc)
	End If

Open in new window

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sjef BosmanGroupware ConsultantCommented:
1. revert to a backup
2. use the Full Access Administrator option to handle all documents
NavHardAuthor Commented:
Unfortunately backup copy is replicated and document is vanished from there as well. How can Full Access Administrator would handle it?? Can you please clear ??
Sjef BosmanGroupware ConsultantCommented:
Here's the recipe:
- open the Domino Admin Client on your PC
- you need to have Admin access to the server
- make sure your name is in the field labelled Full Access Administrators (Server document, Security tab)
- in the Admin client, click Administration/Full Access Administration
- open the database with the invisible documents
- they should be visible now
- make sure you corrected your agent, so you can correct the Readers fields.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NavHardAuthor Commented:
Can you tell me lastly what went wrong in my code. What should I change in it?
Sjef BosmanGroupware ConsultantCommented:
Yep. The code isn't exactly right, with respect to  the Readers fields. Check in an existing document, using the Document Properties window, what the contents are of a Readers field. You'll see something like "CN=Jack Daniels/O=Whiskey", so not the abbreviated name but the full canonical name. It MUST be in that form, otherwise it won't work.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.