Results 1 to 2 of 2
  1. #1
    zomas is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    1

    removing security from not my own database

    chaps i have a database which was not designed by me but i have passwords etc (the designer left it to me to manage). i wish to remove all security so that i may trnsfer the database between computers. if i simply copy the database from the computer it was started on (as was the security) i cannot open it on my own laptop.



    please help with step by step info alt is there a security file which i can bring across with the database. the confusion may have something to do with the workgroup the creator made. i dunno.

    thanks for reading and any help offered

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    To make an mdb without security, create a new mdb and then import all the objects from the old mdb which has security on it (but you'll need to be able to access the old mdb.)

    If MSAccess security was implemented, there is an mdw file which needs to be used in the parameter of the shortcut to open the mdb. The mdw file is crucial so make sure it doesn't get lost or deleted. Depending on how it was setup, you need to find the location of this mdw file.

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

Similar Threads

  1. Security Logon to database
    By sdondeti in forum Security
    Replies: 1
    Last Post: 07-05-2011, 11:41 AM
  2. Removing all letters or all numbers from string
    By Hayley_sql in forum Programming
    Replies: 2
    Last Post: 09-16-2009, 02:01 AM
  3. Removing the delete prompt.
    By botts121 in forum Programming
    Replies: 4
    Last Post: 06-26-2009, 11:45 AM
  4. Database Security
    By marianne in forum Security
    Replies: 4
    Last Post: 06-15-2009, 07:12 PM
  5. removing record from form
    By rsearing in forum Programming
    Replies: 7
    Last Post: 05-14-2009, 10:34 PM

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