Denied permission to copy table into another database

=?Utf-8?B?anNjY29ycHM=?=

Guest

Posts: n/a

7th Dec 2005

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?

« HELP!!! Switchboard Error | Refresh Report Control »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CREATE DATABASE permission denied in database 'master'.	ravi.govindaraju@gmail.com	Microsoft ASP .NET	0	5th Apr 2007 05:10 PM
Create database permission denied	=?Utf-8?B?RGF2ZU0=?=	Microsoft Outlook BCM	4	12th Feb 2007 07:39 PM
CREATE DATABASE permission denied in database 'master'	casper	Microsoft ASP .NET	0	24th Apr 2006 03:41 PM
msi file copy permission denied	narshe@gmail.com	Microsoft Dot NET Framework	0	8th Nov 2005 09:13 PM
FSO permission denied copy file	eric	Microsoft Windows 2000 File System	1	7th Nov 2003 07:16 PM