problem with permitions on make tables queries

[Marco]

Hi. I already make this question in another Theme of this communities.

I'm here with a problem regarding the make tables queries.

The access don't let my user run a make table query because it says that the
user don't have enough permitions.

The user it's not admin but it has all permition the database and that
specific query and table.


In Object type: database I activate the option in:
Open/Run
Open Exclusive
Administter


The user also have in option New Tables/Queries:
Read Design
Modify Design
Administer

And the same option for the query that make the table that my reports needs.

What I'm doing wrong?

Please help.

Regards,
Marco

 

[pietlinden]

Hi. I already make this question in another Theme of this communities.

I'm here with a problem regarding the make tables queries.

The access don't let my user run a make table query because it says that the
user don't have enough permitions.

The user it's not admin but it has all permition the database and that
specific query and table.

In Object type: database I activate the option in:
Open/Run
Open Exclusive
Administter

The user also have in option New Tables/Queries:
Read Design
Modify Design
Administer

And the same option for the query that make the table that my reports needs.

What I'm doing wrong?

Please help.

Regards,
Marco

Why do you need the make table queries to begin with?
It is possible to open another workspace with the permissions from
another account and then do the things that are not allowed under the
original user's account, and then close the session. It would all
happen in code, so the user would be none the wiser. Look up
Workspace in the help.

Why would a standard query not work?