Results 1 to 4 of 4
  1. #1
    midpitts is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    2

    Moving Access Database

    We have created an Access database for a client for a class project. We have set permissions on some of the objects in the database. When we move the database onto the clients computer (using right-click>copy and right-click > paste) the permissions disappear. Is there a way to move this database and keep the permissions we have set?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    What do you mean by 'set permissions on some of the objects'? How was this done?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    midpitts is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    2
    Quote Originally Posted by June7 View Post
    What do you mean by 'set permissions on some of the objects'? How was this done?
    Thanks for responding.

    We used the Manage Users and Permissions in the database. It is located under Info. We set up user and group accounts for new users. The permissions work on the original PC where they were set up on the database, but when it was moved to the server, they no longer held. All objects (tables, queries, forms and reports) were accessible when the should have required a login process as it did on the original PC.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    A database created in A2007 or A2010 isn't even supposed to have these security settings available. Review http://office.microsoft.com/en-us/ac...010342116.aspx

    I am not finding those options with A2007 nor A2010. The only thing I can find is Password Encryption.
    Last edited by June7; 12-04-2012 at 10:57 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Moving Tables from one database to another
    By fishthirty in forum Access
    Replies: 3
    Last Post: 11-21-2012, 04:20 PM
  2. Replies: 0
    Last Post: 06-19-2012, 12:39 PM
  3. Replies: 6
    Last Post: 02-18-2012, 07:20 AM
  4. Problem moving database to another computer
    By DB2010MN26 in forum Access
    Replies: 4
    Last Post: 11-22-2011, 04:23 PM
  5. Problem with Access 2003 database after moving PCs
    By ValiantSaint in forum Access
    Replies: 2
    Last Post: 06-25-2010, 01:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums