Security Question

B

Bunky

I have a Make-Table query in a macro that the user executes to do some daily
work. As you know, it deletes the old table first and then re-builds a table
with the same name. As Administrator, I have no problems in doing this.
However, regardless of the permissions I grant to the user community, it
seems like I have to grant Admin permissions to get the query to run. I do
not want to grant perm Admin permissions to the User. This is the first time
I have used a Make-Table query in a macro if this makes a difference.

Ideas?

Thank you for your assistance!
 
A

Allen Browne

Instead of a Make Table query, set up the table the way you want it and use
a Delete query followed by an append query.
 
B

Bunky

Allen,

Is this the only way to get around the problem? Don't get me wrong, I like
it. But I was just thinking this is bypassing the problem. I will look into
doing this but was just wondering.

Kent
 
D

Douglas J. Steele

It's very unusual to need a make-table query in a production application.
Allen's suggestion is far more practical.
 
Top