No modify design permission for table or query 'TempMSAccessObject'

[Paul]

This is in regards to Jay's message posted May 14, subject Error Message Clarification. My issue is as follows. I am attempting to delliver a secure database in which none of my users belong to Admins. I need one user to be able to compact the database periodically so I created a special user called Owner that has Administer Database permissions. I had hoped that if this user opened the database with the /compact option in the command line that he would be able to compact the database but that failed with the message; Could not create; no modify design permission for table or query 'TempMSAccessObject'. Any suggestions on why this is happening or is there a better way to do this
Many Thanks!!
Pau

 

[GVaught]

You have to make sure that the person who is designated to Compact has
permission to open the database exclusively. Compact should only be issued
against a database that can be set in this mode. This will alleviate the
problem of corruption.

This is in regards to Jay's message posted May 14, subject Error Message

Clarification. My issue is as follows. I am attempting to delliver a secure
database in which none of my users belong to Admins. I need one user to be
able to compact the database periodically so I created a special user called
Owner that has Administer Database permissions. I had hoped that if this
user opened the database with the /compact option in the command line that
he would be able to compact the database but that failed with the message;
Could not create; no modify design permission for table or query
'TempMSAccessObject'. Any suggestions on why this is happening or is there a
better way to do this.