Record Link table

marialorena

Hi,

Message " You do not have permission to read the Record Link Table" was encountered while trying to post an invoice (both in Sales and Purchase). Note that daily normal transaction was only done when this message was reported.

Why did this happen? How can this be resolved without altering the permission to read the Record Link Table?

Thanks!

philippegirod

Record Link is a NAV 6.00 (Navision 2009) system table.
If you have this message isn't it because a link have been added?
Do you have the licence for it?
Does the user have the authorization for it?
You must set a "All users" role which allow reading on the most common tables, eventually with "indirect" method.

marialorena

Hi,

We have been using the application for months already and users are just doing normal sales and purchase transaction when they can not post the invoice and this message related to Record Link table appeared. Anyone who encountered the same?

marialorena

Hi,

We're using only NAV 5.0 SP1. Wondering why the message appeared. Our users are just doing a normal everyday transaction when they can no long post both in Sales and Purchase. Pls advise how to fix this even without giving permission in the Record Link Table.

Thanks.

ara3n

delete the records from record link table and you won't get the permission error.
My guess somebody with permission inserted a record into the table. and users started getting the read permission error because there are now records in the table.

marialorena

delete the records from record link table and you won't get the permission error.
My guess somebody with permission inserted a record into the table. and users started getting the read permission error because there are now records in the table.
_________________

Hi,

There is no record found in the Record Link table when the permission error occured..anyone has encountered the same scenario?

ara3n

may I ask how you found this out?

Thanks

marialorena

may I ask how you found this out?
_________

The users are just doing normal Sales and Purchase transaction. When about to post the Invoice then the message appeared.

Thanks

ara3n

Sorry what I wanted to know is how did you check that there is no record in the record link table.

Also has somebody modified any posting routine to access the record link table?

maybe transfer the data in record link to the posted documents?

Thanks.

marialorena

I run this Table 2000000068 Record Link and found no record at all.
This object was never modified also.

Please help.
Thanks.

Belias

marialorena wrote:

I run this Table 2000000068 Record Link and found no record at all.
This object was never modified also.

Please help.
Thanks.

enable debugger, disable breakpoint on triggers, and see where the execution stops. If you don't understand the code, try to post it here.
P.S.: you can use "quote" button to quote other people's messages

Sandra

Hallo Marialorena,
how did you solve the problem? We encounterd the same problem after doing a technical update last weekend. So I gave everyone readpermissions, but today another user called and had the same problem again. So I checked - there was one record in the table. So I deleted it - no go. The user then exited Navision and called it up again and everything was alright.
What I do not understand is: deleteting a record is data. Data is made available to everyone without leaving Navision.
Why did the read permission not work???
Thanks
Regards
Sandra

ara3n

When you change permission, users have to log out and back in to get the new permission. And my guess that one users was still connected and never had logged out.

Sandra

yes they all logged out and logged back in again. I changed the permission on Monday! And today is Wednsday. The User are logged out automatically at night so even if thy forgot it would have been changed.

Regards
Sandra

ara3n

Sandra wrote:

yes they all logged out and logged back in again. I changed the permission on Monday! And today is Wednsday. The User are logged out automatically at night so even if thy forgot it would have been changed.

Regards
Sandra

What do you mean by Logged out automatically at night?

Belias

if you don't understand where's the problem, try to put an error in Oninsert trigger of recordlink table:

ERROR('Immediately call Sandra to report this error, thanks');

the user will call you and he can tell you how did he generated the error...

marialorena

Where is it called for the Record Link table and how to use it for custom tables?

______________________
Hi Alex,

Were you able to get answer for this...

ara3n

It's a new feature added in 5.0 and higher.

you click on a new menu button that is beside Paste button.