.auc file

Sometimes users receive error like below, which says

User 'UserName' is not authorized to insert a record in table 'TableName'. Request denied.
Cannot create a record in TableLabel (TableName). Access Denied: You do not have sufficient authorization to modify data in database.

Clearing the user's usage data won't help. What i tried (and worked :)) was to delete the user’s .auc file, which solved the problem.
Search for .auc file at Location : “C:\Documents and Settings\%USERNAME%\Local Settings\Application Data”

The purpose of the object caching file (.auc) is to store a local copy of the AOT objects which have been used by the client, so that in the future they do not need to be re-read from the AOS.

We can also change the table’s (EmplTable, in our case) properties like AosAuthorization and MaxAccessMode, which can solve the issue. But the issue was in production environment and I needed a quick fix.

Links: http://blogs.msdn.com/b/emeadaxsupport/archive/2009/05/07/user-username-is-not-authorized-to-insert-a-record-in-table-tablename-request-denied.aspx

http://www.axaptapedia.com/index.php/Object_caching

Hope it is useful.