Report wont open for non admin users

[inbreda]

Hi

I have a multi user database, and I've added a new report. If an admin user
is using the database the report opens as it is meant to.

If a non admin user is using the database, when they try to open the report
the on open event runs (docmd.runsql to make a table which the report then
refers to), but the report itself fails to open.

I have checked every box (and every combination of boxes) for non admin
users through the security>user and group permissions, but the problem still
exists.

I've posted my question here because it must be something to do with the
user security permissions.

Please someone - help me !

 

[inbreda]

Further info:

I've moved things around a bit and I now get the error message:

"You do not have the necessary permissions to use the <datatable> object.
Have your system administrator or the person who created this object
establish the appropriate permissions for you"

I gave full permissions to this table and now I get the message "Could not
create; no modify design permission for table or query <datatable>

I assume this is something to do with non admin users not being able to
create tables (because the on open event of the report I'm trying to open
runs a docmd.runsql command that makes a table).

The oddest thing is that it is not the only 'make table' query that is in
the database, and non admin users don't have a problem running the other
ones?!?!?!?!

Thanks

I