Re: Is the anyway I can import database that is secured? Please help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"Blinda" <Blinda@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:70CB5102-6242-43D8-9AE5-6CA9DF78D918@xxxxxxxxxxxxxxxx
> Dear all,
>
> When I try to import a table from a secured database (I set up the
> security
> for this database) to another secured database, the following information
> was
> shown up:
>
> You do not have the necessary permission to the '*.mdb' object. Have your
> system administrator or the person who created this object establish the
> appropriate permissions
>
> Please help me for this problem. How can I set the appropriate permissions
> for it?


If the two mdb files were secured using the same workgroup file, then log in
as a user who has permissions to the tables.

Probably though, you secured them with different mdw files? If so, then
create the exact same user in both - i.e. same username/PID. Assign
appropriate permissions to this user, and they'll be able to import.

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • RE: User Level Security Malfunction
    ... The 10 Commandments of Group Level Security ... Many of the secured databases I deal with only require a database password, ... and Permissions; how to use them and how to create them. ... While you can undo or make corrections to your secured database, ...
    (microsoft.public.access.security)
  • Re: Is the anyway I can import database that is secured? Please he
    ... Thank you very much and you have a good day, Blinda ... "Joan Wild" wrote: ... >> for this database) to another secured database, ... How can I set the appropriate permissions ...
    (microsoft.public.access.security)
  • Re: creating workgroupfile for remote administration
    ... Say you distribute a workgroup file with your secured database. ... sufficient permissions to create new users. ... dim ws as workspace, usr as user ...
    (microsoft.public.access.security)
  • multiuser security on the network
    ... I have questions about setting up a secured database for multiple ... users on a network. ... groups and appropriate permissions for groups. ... Whenever steve opens the secure database on the network drive, ...
    (microsoft.public.access.security)
  • Re: Is the anyway I can import database that is secured? Please help
    ... Blinda wrote: ... > When I try to import a table from a secured database (I set up the ... > security for this database) to another secured database, ... > establish the appropriate permissions ...
    (microsoft.public.access.security)