Make table permissions

[honeypot3]

Hi there

I have a front end MDB file which contains some make table queries that create / overwrite tables in a linked backend database which work fine when I am logged in as an an administrator. However, when I log in as a data user to whom I have applied full admin rights over the tables concerned in both the back end and front end files - it keeps telling me that I do not have the necessary permissions to use the table objects in question. Have I missed something - are there some other permissions I need to give in order for these make table queries to work for other users?

 

[hneal98]

Did you set the permissions for the user or for the group?

 

[honeypot3]

For the group - but don't worry - I have worked around it by changing Make Table for a Delete and Append query routine that works fine. Thanks