I have to create a table before running a report. The table cannot be
generated through queries because it requires a series of queries that end up
with multi level group by's not allowed and the last query needs to be a
cross tab.

Without the admin privileges the user gets an error that they cannot modify
the design of a table. I have tried giving the user all priveleges for new
tables but this hasn't helped. Any suggestions?
--
Susan

Instead of deleting/creating a table each time, you could create your table, and then use a delete and append queries to empty/populate the table. You could make these queries RWOP and the user wouldn't need any permissions on the table.

--
Joan Wild
Microsoft Access MVP
"SusanK" <(E-Mail Removed)> wrote in message news:5AFB08CA-F7C7-4939-BDDF-(E-Mail Removed)...
>I have to create a table before running a report. The table cannot be
> generated through queries because it requires a series of queries that end up
> with multi level group by's not allowed and the last query needs to be a
> cross tab.
>
> Without the admin privileges the user gets an error that they cannot modify
> the design of a table. I have tried giving the user all priveleges for new
> tables but this hasn't helped. Any suggestions?
> --
> Susan