Error 3111 Table or Query TMP%#MAU@

[rsmccli]

I am getting this error using Refreshlink from code. No problem for admins, only some normal users. It says Error 3111: you have no permissions for Table or Query TMP%#MAU@. This object does not appear to exist.

Could this be a deleted table or something? I don't get it, this was working fine this morning.

For Each tdf In db.TableDefs
    If tdf.Name = "tblMasterList" Then
    ElseIf VBA.Len(tdf.Connect) > 0 Then
      tdf.Connect = ";DATABASE=" &  strNewPath
      tdf.RefreshLink
    End If
Next

Thank you.

[MMcCarthy]

Run a loop to print out the table names in the immediate window and see if this name appears on the list and if it is extra or if an expected table name is missing.

For Each tdf in db.TableDefs
    Debug.Print tdf.Name
Next
 

[rsmccli]

I just wanted to update this for others searching with the same problem.

This problem only affected some of my security usergroups, and actual table and query permissions seemed to have no bearing on this error happening (my Read Only usergroup worked fine, but some groups with all but admin privileges were affected). Since this temporary table is not accessible from the security/permissions GUI, I was unable to fix the problem there.

I did list all tabledefs and querydefs; the table was not shown.

In the end I had to create a new blank .mdb file, import all objects, and re-do security permissions. Now all usergroups are able to refresh table links with no problem.

Hope this helps someone in the future.