Security Question

[Guest]

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!

 

[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.

 

[Guest]

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

 

[Douglas J. Steele]

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

 

[Guest]

Thank you both for your insight and wisdom. You both are the greatest!!!