LookUpRecord Fails When Called from On Start Macro (via Data Macro) in Access Web App (Error 2950)

Question

I have a SharePoint/Access web app.  I have built a data macro to lookup a record in a table of email addresses based on the UserEmailAddress() value passed to the data macro from the On Start macro for the app.  I simply want to return a value at startup to indicate whether or not the user's email address is present in the table.  When I start the app I get an error that traces to error code 2950 on the data macro.  I don't see anything wrong in my macro code.  The error stating "you do not have permission to edit the records" makes no sense since the function I am calling is just viewing the records.

I can't find anything useful online to help troubleshoot this problem.  I'm dead in the water.

BTW, I tried to include a screen shot of the error message, but was not allowed because my "account is not yet verified".  Thanks, Microsoft!

Postscript... this just got stranger.  It now appears I cannot touch the table I am referencing AT ALL.  I have deleted the table and recreated it twice with the same result.  And it is only this table that is affected.  Very weird!

Post-Postscript... Never mind.  Microsoft corrupted my database somehow.  Closing and reopening seems to have fixed it.  Now if I could only get my day back.

Answer 1

Good Morning Mike,

To expedite your account activation please follow the link below. The reason the account requires activation is to help protect the Forums and the volunteers here.

Hth,

https://social.technet.microsoft.com/Forums/en-US/3fba9006-9471-4ebb-81fe-143d3d2a6e38/verify-your-account-32?forum=reportabug

---

Just takes a click to give thanks for a helpful post or answer.
Please vote “Helpful” or Mark as “Answer” as appropriate.
Chris Ward
Microsoft Community Contributor 2012

Answer 2

Do you get all records returned to the view if you do not set the criteria to a specific value?

---

Just takes a click to give thanks for a helpful post or answer.
Please vote “Helpful” or Mark as “Answer” as appropriate.
Chris Ward
Microsoft Community Contributor 2012

Answer 3

I'm not attempting to return any records to any view.  I just want a single record from which I pass the value of a single column into a return variable.  Seemed pretty simple to me.  I've used the same code to pass values into form controls with no issues.  This all seems to be tied to the fact that I'm calling the data macro from an On Start macro.  But I don't know why.

Even if it is a criteria issue, the lookup function should run with criteria that returns no results and simply return a null record, if there is no match -- according to the documentation.

Answer 4

We are doing the research about your problem. There might be some delay about the response. Appreciate your patience.