upgraded to Access 2007 from 2003 - lost admin rights

Discussion in 'Access Security' started by Linda, Mar 1, 2010.

  1. Linda

    Linda Guest

    Our office upgraded from 2003 to 2007 and since then, I am unable to make any
    changes to the database. I was very careful in 2003 to set up security and
    save all the workgroup information. I can open the database and all of the
    tables, etc., but can't figure where to enter all of the WID info, etc. that
    should be in place.

    I am a basic user who unfortunately has no support at work, hence I must
    turn to this group for assistance.

    I did see message references to inserting this into the properties - but
    "path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
    Also, would the "path" be the drive access resides on? Sorry to be so
    dense, I am NOT a programmer!

    Thanks for your assistance.
    Linda, Mar 1, 2010
    1. Advertisements

  2. On Mon, 1 Mar 2010 10:54:01 -0800, Linda

    That phrase:
    "path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
    refers to making a shortcut. Right-click on the desktop and choose New
    You will see a field named Target. That's where you type a long
    string. The first part of that string is the exact location of
    msaccess.exe. Typically it's a location such as:
    "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"
    Note how I put double-quotes around the text. This is required if
    there are funny characters like spaces in the text. Use your
    computer's Search feature to search for msaccess.exe.
    Next in the long string is a space, then the exact location of your
    database. Then another space, then /wrkgrp, and finally the exact
    location of the .mdw file that is used by your application. This is
    the security file that may be hardest to find. Again use your search
    feature. Also check possible previous shortcuts for this information.

    Microsoft Access MVP
    Tom van Stiphout, Mar 2, 2010
    1. Advertisements

  3. Linda

    Linda Guest

    Tom - I just saw your response - for some reason, the notification email was
    turned off. Anyhow, I just tried the string you suggested. Here is what I
    typed in (actually cut and pasted in most cases):
    "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Documents and
    Settings\linichols\My Documents\FARGAS\db R3 FARGAS " /wrkgrp "C:\Documents
    and Settings\linichols\Application Data\Microsoft\Access\System5"

    I am now getting a message whiile Access is opening that says "Microsoft
    Access couldn't find the file 'C:\Documents and
    Settings\linichols\Application Data\Microsoft\Access\System5'
    This file is required for startup.

    I copied the string right off of the search screen, so I know it is correct,
    and I can go to the file and open it.

    Any suggestions?
    I feel that I must be getting close!
    Linda, May 25, 2010
  4. On Tue, 25 May 2010 09:35:01 -0700, Linda

    The second part of the shortcut is not a path to the mdb, or it would
    include ".mdb" (or any of its cousins) at the end. The same thing with
    the path to the .mdw file.
    You must have Windows Explorer configured with the default settings
    which include "hide extensions for known file types". This is not
    appropriate for programmers. We need to see the full filename.

    Microsoft Access MVP
    Tom van Stiphout, May 26, 2010
  5. Linda

    Linda Guest

    I made the changes and added mdb and mdw to the appropriate files. I am
    still gettting a message that says Access can't find the files.
    Linda, May 27, 2010
  6. Linda

    Joan Wild Guest

    please post what you currently have in the target of the shortcut (you
    can copy and paste it)

    Joan Wild
    Joan Wild, May 28, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.