You are not authorized to access table ‘MyTable'. Contact your system administrator.

(0) Share

Report

Posted on by ismaelivan

578

I have a table (created by me) in a form, but some users can not open the form, it shows the following message. "You are not authorized to access table ‘MyTable'. Contact your system administrator.".

I have created other forms in the same way and this has not happened to me.

- Now check the permissions on form> permissions> table and they are correct.

- Also the property visible and is in true, allowedit(true), block(false), allowcreate(true)

- The table is not in any role

The error shows it when the super () form is executed.

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Sort by

ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!

Create a new form with other tables and show me the same error. But I realize that it only happens with tables created this year.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

This error can happen because of the indexes,delete actions or relations defined in the table are not accurate.

make sure they are correct. also check if the extended data types you are using for the table fields have accurate relations if they have any.

is it a regular AX table? or is a view?

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!

Is a regular table and no have relations or edt

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Are you able to open the table explorer and create a new record in the AOT?

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!

Yes, with my user if I can.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

double check if the license configuration is enabled for this table.

Was this reply helpful? Yes No
Shabir Ahmad 3,124 on at

Like (0)

Report
Copy link

Link copied!

I have the same error , all configuration keys are enabled from system Admistration -> Setup -> license configuration.

Was this reply helpful? Yes No
Eunice Hammond 10 on at

Like (0)

Report
Copy link

Link copied!

Any solutions because I am also having the same issue. It's a view created by the developer. I have system admin rights but I still get the error. I created new privilege and assigned it to a role which is assigned to my user but the same error.

Was this reply helpful? Yes No
Suggested answer

Arunraj Rajasekar 1,743 on at

Like (0)

Report
Copy link

Link copied!

Hi Eunice,

Please ensure that all of the fields in view have a valid data source and data field.

Was this reply helpful? Yes No