multi-user security and make table queries

[jjonesal]

I have a database that I have enabled for multi-user security. Created users and groups, and set permissions on objects. However, when I'm setting permissions, Access won't allow me to set permissions for the object name <New Tables/Queries>.

It gives me this error message:

You can't change permissions for '<New Tables/Queries>.'

To change permissions for this object, you must have Administer permission for it. For more information on permissions and who can set them, click Help.

The account I'm logged in is in the Admins group, but when I try to give the Admins group Administer permissions, I get the same error.

My problem is that one of my reports has to have this permission because the macro invoking it builds some temporary tables to aggregate data in a special way.

All my other permissions are fine, but I'm pulling my hair out with this one.

If anyone has any ideas - I'd definitely appreciate it....

Thanks in advance

 

[straybullet]

Have you logged in as the "owner"? If not possible, can you change the ownership?

Let them hate - so long as they fear... Lucius Accius

 

[jjonesal]

Sure did. Funny, the owner doesn't have Administer privileges to it, but I get the same message. The only acct that has Administer privileges is Admin. I had removed "Admin" from the Admins group. So I tried adding it back. And tried logging on as Admin... still no luck.

I'm stuck here.