Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

HELP!!! Access 2007 and .mdw

Discussion in 'Information Technology' started by Sam, Jul 28, 2006.

Tags:
  1. Sam

    Sam
    Expand Collapse
    Guest

    I need to open an Access 2003 secured database (with workgroup, users, etc)
    in Access 2007 but I can't find the join workgroup command to attach the
    database to the .mdw file on my computer!

    The pre-release version (Office 12) had it and I know microsoft's moving
    away from it in Office 2007 but how can I get around it and open previously
    secured files?????

    I receive the well known msg : "You don't have the necessary permission
    to..."

    Any ideas on how I can get around this?
     
  2. Loading...


  3. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi, Sam.

    First, please don't multipost. People will end up answering you question in
    one newsgroup, only find that someone else has already answered it in
    another newsgroup. When they find you've wasted their time, they're less
    likely to want to answer your questions next time.

    >I need to open an Access 2003 secured database (with workgroup, users, etc)
    > in Access 2007 but I can't find the join workgroup command to attach the
    > database to the .mdw file on my computer!


    It's not there. Create a new form and a button on it named WkGrpAdminBtn.
    Copy and paste the following code into a form's module, then save and
    compile. Open the form in Form View and select the button, and the
    Workgroup Administrator dialog window will appear, allowing you to join a
    workgroup.

    Private Sub WkGrpAdminBtn_Click()

    On Error GoTo ErrHandler

    DoCmd.RunCommand acCmdWorkgroupAdministrator

    Exit Sub

    ErrHandler:

    MsgBox "Error in WkGrpAdminBtn_Click( ) in" & vbCrLf & _
    Me.Name & " form." & vbCrLf & vbCrLf & _
    "Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
    Err.Clear

    End Sub

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    "Sam" <Sam@discussions.microsoft.com> wrote in message
    news:D6FA7DD1-8D17-46E0-9340-68E270564109@microsoft.com...
    >I need to open an Access 2003 secured database (with workgroup, users, etc)
    > in Access 2007 but I can't find the join workgroup command to attach the
    > database to the .mdw file on my computer!
    >
    > The pre-release version (Office 12) had it and I know microsoft's moving
    > away from it in Office 2007 but how can I get around it and open
    > previously
    > secured files?????
    >
    > I receive the well known msg : "You don't have the necessary permission
    > to..."
    >
    > Any ideas on how I can get around this?
     
  4. Sam

    Sam
    Expand Collapse
    Guest

    > It's not there. Create a new form and a button on it named WkGrpAdminBtn.
    > Copy and paste the following code into a form's module, then save and
    > compile. Open the form in Form View and select the button, and the
    > Workgroup Administrator dialog window will appear, allowing you to join a
    > workgroup.
    >
    > Private Sub WkGrpAdminBtn_Click()
    >
    > On Error GoTo ErrHandler
    >
    > DoCmd.RunCommand acCmdWorkgroupAdministrator
    >
    > Exit Sub
    >
    > ErrHandler:
    >
    > MsgBox "Error in WkGrpAdminBtn_Click( ) in" & vbCrLf & _
    > Me.Name & " form." & vbCrLf & vbCrLf & _
    > "Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
    > Err.Clear
    >
    > End Sub


    Thanks for the Help!

    > First, please don't multipost. People will end up answering you question in
    > one newsgroup, only find that someone else has already answered it in
    > another newsgroup. When they find you've wasted their time, they're less
    > likely to want to answer your questions next time.


    ....and the advice!!!
     

Share This Page