By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,390 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Error 3111 Table or Query TMP%#MAU@

rsmccli
P: 52
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.

Expand|Select|Wrap|Line Numbers
  1. For Each tdf In db.TableDefs
  2.     If tdf.Name = "tblMasterList" Then
  3.     ElseIf VBA.Len(tdf.Connect) > 0 Then
  4.       tdf.Connect = ";DATABASE=" &  strNewPath
  5.       tdf.RefreshLink
  6.     End If
  7. Next

Thank you.
Mar 13 '08 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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.

Expand|Select|Wrap|Line Numbers
  1. For Each tdf in db.TableDefs
  2.     Debug.Print tdf.Name
  3. Next
  4.  
Mar 14 '08 #2

rsmccli
P: 52
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.
Apr 30 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.