Security - allow Query building, but not Table building/modification

[workaholic_tor]

I've been trying to figure this out, but it looks like a no go.

I wanted to give my users the ability to create/modify queries, but NOT create/modify tables.

Does anyone know if this is possible in Access 2002?

Thanks,

Earl

 

[gemma-the-husky]

i dont think you can

query and table are essentially the same thing

 

[RV]

You could set up security and permissions.

I strongly advise you not to even consider giving users direct access to queries.
This will enable users to screw up your table data.

RV