create table permission

N

neeraj

I have implemented user level security on my database using wizard. There is
one report in this database which requires a macro to be run first. The first
step in this macro is a make table query. This query makes a table, say
Table1. I have created a group, say Group1 which has a few users say user1,
user2. When I am logged in as user1 and I try to open the report or run this
macro on its own, it gives an error mesage saying 'could not create; no
modify permission for table or query 'Table1'. Till here, Group1 had only
read read data and read design permission on all tables in the database.
After I got this error message, I logged in as the administrator say Admin1,
then went on to provide all permissions to Group1 for Table1 including modify
design but excluding administer. I then logged back as User1 and ran the
macro again but it gives the same error message. Everytime a make table query
is run, it deletes that table first if it is already there, and User1 cant
create it. How can I resolve this? (I also observed that running the macro
while logged in as Admin1 created Table1 and changed the permissions of
Admin1 as a user for Table1 to all permissions including administer from none)
 
R

Rick B

I could be wrong, but I have never had a need to build a table in Access
using the maketable feature. Nor have I ever needed to build a macro.

What are you trying to accomplish? Can't you base your report on a query
rather than making a table?

Not sure about the cause of your actual error, but it seems to me that you
are jumping through hoops to run a report that could probably be done
without the need to run macros or create temporary tables.


--
Rick B



neeraj said:
I have implemented user level security on my database using wizard. There is
one report in this database which requires a macro to be run first. The first
step in this macro is a make table query. This query makes a table, say
Table1. I have created a group, say Group1 which has a few users say user1,
user2. When I am logged in as user1 and I try to open the report or run this
macro on its own, it gives an error mesage saying 'could not create; no
modify permission for table or query 'Table1'. Till here, Group1 had only
read read data and read design permission on all tables in the database.
After I got this error message, I logged in as the administrator say Admin1,
then went on to provide all permissions to Group1 for Table1 including modify
design but excluding administer. I then logged back as User1 and ran the
macro again but it gives the same error message. Everytime a make table query
is run, it deletes that table first if it is already there, and User1 cant
create it. How can I resolve this? (I also observed that running the macro
while logged in as Admin1 created Table1 and changed the permissions of
Admin1 as a user for Table1 to all permissions including administer from
none)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top