can't get PERMISSION on new table

[hazelett]

I am trying to secure my database. Everything is going OK except I have a query that creates 2 tables that I combine for a report. I assign permission to the tables and all looks ok. But when I run the report I am told I do not have permission to the table. I think it is because the table is deleted and created new each time the report is run so I lose my permissions each time. Is there a way around this? Any help would be most appreciated.
-- Terry

 

[neillovell]

The table is deleted each time? Cool, didn't know you could do that. Why did you choose to do that though?

How have you got on securing your database elsewhere? Is everyhting else ok? I ask b/c I managed to lock myself out of Access three times while trying to set security.

what about if you log in as a member of the Admins group? I'm thinking Admin members have 100% permissions so it shouldn't question you...

 

[thornmastr]

Terry,

I assign Access security by User group so I do not have to be concerned about individual users. For that group who will be deleting, creating tables, you need, under user/group permissions under tables under new tables/queries, you obviously wish to assign administrative rights since members of that group will be dropping and creating tables.

HTH
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[hazelett]

I finally got it figured out. I now assign groups such as data entry personnel to the forms they need and setup other groups for different functions. I then assign a group to a user. I had it backwards by trying to set each user up with their permissions. I am using a security manager add in I found on the microsoft knowledgebase that helps me manage the assignments. Thanks for everyone's input.
Terry