Updating Lotus notes data from different location

[sam2601]

Hi guys,

We have a lotus notes app and we need to feed this lotus notes data in MSAccess MDB which is on different server location.So we have coldfusion interface which is doing this job after feeding the records we need to update the lotus notes data field so that the same record won't be feed again into the access database.Previously the update function was working fine and lately we had a new version of drivers and Lotus notes Client installed on this system from then when ever we do an update function it is giving an error

[Lotus][ODBC Lotus Notes][Lotus Notes Server]Notes API driver error: You cannot update or delete the document(s) since you are not listed as an allowable Author for this document

Any ideas as to what is causing this error.

Thanks in advance guys.

 

[pmonett]

It would seem that your issue is more an access rights issue than an update or driver issue. Given that you appear to say that the function is triggered manually, it is the ID used on the Notes client that should be checked.
I would check if all the elements of this function are still properly configured. For example, can you open the Notes db and access its content normally ?

Pascal.

 

[Troodos]

[Lotus][ODBC Lotus Notes][Lotus Notes Server]Notes API driver error: You cannot update or delete the document(s) since you are not listed as an allowable Author for this document".

As said in previous posting, this seems to be only access rights towards the Notes db unless there is some settings activated so the ODBC driver only allows 'read-only'. Make sure that is not the case.

Check the ACL on the database. Find user(s) or maybe even better a SERVER with EDITOR rights or higher. I assume the login to Notes is from ColdFusion via ODBC. Then try again.

If this is an agent, see if you can set 'Run as user' in the agent properties for a guaranteed EDITOR or higher (Needs designer access to enable this).



Brgds,

TrooDOS
-- Never so bad that it could not be worse --