permission to create new table

[John Milbury-Steen]

Hi Access gurus,

I am using user-level security in Access 2002. In my database I have a
make-table query. I want one group of users to be able to use it, but I
(the only member of Admins) am the only one who can. The others get the
message: "Could not create; no modify design permission for table or query"
and then it gives the name of the table it tried to create. The query and
the old table DO have modify design permission. What to do?

 

[Arvin Meyer]

Try adding:

WITH OWNERACCESS OPTION

to the end of the query (before the semi-colon)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access