grant security access in a macro

  • Thread starter Thread starter Jessica E
  • Start date Start date
J

Jessica E

i'm running a macro where the series of steps involves
deleting a table and recreating it with a make-table
query. i do this because the column headings change each
month (it's a series of dates within a time period). i
then append 3 other queries information to that table. i
have security set up on the database so that users only
have specific access, but when the table is recreated,
they don't get their access to the table back and cannot
complete the macro.

here is my question:

1. is there a better way to get all the data in one spot
while accounting for the changing column names (monthly)

2. if not, is there a way to write "grant" access into the
macro? i know it can be done with SQL but i'm not getting
the wording or something right.

Any help is EXTREMELY appreciated!!
thanks!
Jessica E
 
Is that the best way to handle your data?

Usually, anytime you are changing the structure of your
data signifies a problem with the design. I would look at
using crosstab queries and keep your data normalized.

But, to answer your question, you have to set the queries
to run WITH OWNER ACCESS. Open the query in design view,
then click on View, Properties.

Change the Run Permissions property to Owner's.

Chris Nebinger
 
Back
Top