Re: Can't Import/Export Tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Yes, it's *very* strange indeed! I checked again and, yes, I'm the db owner
for both databases. I'm still getting this message:

"Could not create; no modify design permission for table or query..." and
then it gives the name of the table. It pops up for each table I've tried to
import or export.

I have confirmed (twice) that I'm the owner of the object. As well, I have
full permissions through the "Developers" group I created. One thing I have
noticed, though, is that the "Developers" group shows the "Administer"
permission checked but, when I look at my cumulative permissions while
viewing my username, the "Administer" permission is *not* checked. The sum
of permissions on both screens is 852222. I wonder if that's part of the
problem?

Anyway, I'd appreciate any additional hints or help you could give me.

Regards, Chris


"Keith Wilby" wrote:

"Chris O''Neill" <ChrisONeill@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0FEF3408-A5FC-4269-873D-68096217F9BC@xxxxxxxxxxxxxxxx
I'm getting a "no modify design permission" error message when I try to
import or export a table from one secured MDB file to another.

Hi Chris,

This is odd because, by importing or exporting, you're not actually
modifying anything. I've just tried an import and export under the same
conditions and they both worked. Are you sure you're the owner of the
*database* object?

Regards,
Keith.


.



Relevant Pages

  • Re: Permissions for login?
    ... maintaining some level of version control for the databases. ... >>data if they are the owner of the table. ... >>permissions to modify data. ... >>>able to modify data within the objects created after the object has ...
    (microsoft.public.sqlserver.security)
  • Re: File and Folder Permissions
    ... What may work is if you give creator owner modify permisions. ... > I set special permissions by unchecking the Delete, ... > If I try to save it again Windows prompts me if I want to overwrite the ...
    (microsoft.public.windows.server.security)
  • Re: Permissions for login?
    ... data if they are the owner of the table. ... permissions to modify data. ... TABLE permissions. ... Will the ddl_admin role work for this? ...
    (microsoft.public.sqlserver.security)
  • Re: File and Folder Permissions
    ... still user is able to modify the permissions any more ideas ... remove "Creator / Owner" ... >> rights for files and folder stored on the NT serve. ...
    (microsoft.public.win2000.security)
  • Re: NTFS Add & Read Directory Permissions
    ... > still modify its permissions. ... Yes, because the owner of a file can always change the permissions, ... You can't give away ownership, ...
    (comp.os.ms-windows.nt.admin.security)