TMP%#MAU@ problem

[Paul]

HI!

I have a FE/BE solution with Access 2002. Every once in a while I like to
import into a blank database to clean things up. After the import I manually
set permissions on all objects, a tedious process, so I thought I would do it
in code by going through the Containers and Documents. All looked pretty good
until I tried to relink to a different BE. I have a dedicated user 'Owner'
that has necessary persmissions to do this, or so I thought. When I try to
relink by setting permissions in code, I get: error 3111, could not create:
no modify design permission for table or query TEMP%#MAU@. I dont' have this
problem if I set permissions manually???
This must be some sort of internal or temporary table that I have access to,
so I can't figure out how to debug this. I dumped all documents for 'Owner'
and this table doesn't show anywhere.
Any help would greatly be appreciated.
Thank You.
Paul

 

[Joan Wild]

See DbUtilities 1.0 at http://www.accessmvp.com/SDaigle/index.htm for sample code.

 

[Paul]

Thank you, I'll take a look!

See DbUtilities 1.0 at http://www.accessmvp.com/SDaigle/index.htm for sample code.

 

[Paul]

Follow up:

After some intensive searching I discovered that my user 'owner' needs
dbSecCreate permission on his 'Table' Container to avoid this error. This
permission option doesn't show in the GUI when setting permissions. It took
some digging to find it in code, but all is good now.
Thank You!

 

[gviau]

Do you mind sharing your problem fix with us as I am having the same problem and trying to figure out how to fix it.

Thanks.