problem with permitions on make tables queries

[Marco]

Hello.

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

 

[Joan Wild]

Hi Marco,

I've had better success in creating the necessary table, and then running a delete query followed by an append query to repopulate the table.

--
Joan Wild
Microsoft Access MVP
: Hello.
:
: 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
:
:
:

 

[Marco]

Hi. But why?

If is an option shouldn't it work?

Any reason?


Regards,
Marco

 

[Joan Wild]

I suppose they don't have permissions on the underlying tables (in the backend) in the query. Are you modifying the SQL of the query in code? Is the query RWOP? Are there lookup fields in the underlying tables?

The permissions you put on <New tables/queries> don't have a role here. Those permissions don't have anything to do with 'whether' a user can create them; they are permissions that will apply on any new table/query that is created (by anyone) in the mdb. That is moot, since the user running the make table query will be the owner of the table created, and as such can do anything with that table, regardless of the permissions.

--
Joan Wild
Microsoft Access MVP
: Hi. But why?
:
: If is an option shouldn't it work?
:
: Any reason?
:
:
: Regards,
: Marco
:
:
:
:
: "Joan Wild" wrote:
:
: > Hi Marco,
: >
: > I've had better success in creating the necessary table, and then running a delete query followed by an append query to repopulate the table.
: >
: > --
: > Joan Wild
: > Microsoft Access MVP
: > : Hello.
: > :
: > : 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
: > :
: > :
: > :
: >

 

[Marco]

So it means that I'm dead

 

[Joan Wild]

Why? You can work away at getting the make table query to work, or just try the delete query, followed by the append query.

--
Joan Wild
Microsoft Access MVP
: So it means that I'm dead
:
:
:
: "Joan Wild" wrote:
:
: > I suppose they don't have permissions on the underlying tables (in the backend) in the query. Are you modifying the SQL of the query in code? Is the query RWOP? Are there lookup fields in the underlying tables?
: >
: > The permissions you put on <New tables/queries> don't have a role here. Those permissions don't have anything to do with 'whether' a user can create them; they are permissions that will apply on any new table/query that is created (by anyone) in the mdb. That is moot, since the user running the make table query will be the owner of the table created, and as such can do anything with that table, regardless of the permissions.
: >
: > --
: > Joan Wild
: > Microsoft Access MVP
: > : Hi. But why?
: > :
: > : If is an option shouldn't it work?
: > :
: > : Any reason?
: > :
: > :
: > : Regards,
: > : Marco
: > :
: > :
: > :
: > :
: > : "Joan Wild" wrote:
: > :
: > : > Hi Marco,
: > : >
: > : > I've had better success in creating the necessary table, and then running a delete query followed by an append query to repopulate the table.
: > : >
: > : > --
: > : > Joan Wild
: > : > Microsoft Access MVP
: > : > : Hello.
: > : > :
: > : > : 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
: > : > :
: > : > :
: > : > :
: > : >
: >

 

[Marco]

Let me tell you way.

Because I have several different queries, that use tha same table name but
with different fields and with different meanings. I did it because I thought
that it could be a good solution so I didn't need to make too many tables.

I think I found a solution. If you change the table onwer to a group it
works fine. the problem is that when you run the query the table onwer change
to the last user.

Imagine, I change the table onwer to group Users, then if I run with my user
Marco the new onwer it's Marco and not the group Users.

The problem is when a different user uses the program so it change the onwer.

If I it could be possible I create a VBA command that automatically change
the owner to Users when the program starts.

I'll also try some as delete the table when the program Exits.


Regards,
Marco

 

[Marco]

I think this is a solution.

If you do something like delete the table when you close the program the
next time I'll open you won't have troubles.

I'll keep testing.

Marco