Denied permission to copy table into another database

J

jsccorps

Using The IN clause to copy table into another database:

SELECT Employee .* INTO Employee IN 'Backup.mdb' FROM Employee

Get the error message: "Could not create; no modify design permission for
table or query 'Employee' <Error 3111>

I've given all users Read/Modify permissions for New Tables/Queries -
still does'nt work
I've given all users Administer permissions for New Tables/Queries - still
does'nt work
I've given all users Administer permissions for the Database - still
does'nt work

Any ideas?
 
Top