Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    233

    Unanswered: Link table from a Secure database

    Hi,

    Does anyone know how I can link tables from a MS Access db that has the security on.

    Thanks,

  2. #2
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    DB Password?

    If by security you mean it has a db password, then obvisiously you need to know that. When you try to link to that db it will prompt you for it.

    Good luck, Stu
    --If its free, take it for what its worth!

  3. #3
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    This is linking to the MS Access security user names and passwords and groups etc. DB protection that just has a password. I have full access to user names and passwords and I can create groups if I want.

    I do not get promtted for a user name or password. It comes up with a message "You do not not have permissions contact your systems administrator".

    I have tried to use an ODBC connection but again I get the same message.

  4. #4
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    Hi,

    I did''nt get an overwhelming response to this one. Has anyone tried this and failed or has anyone tried this and suceeded more importantly. This is the standard MS Access user-level security I am talking about. And, I have full admin rights.

    Thanks.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you are getting the message "You do not not have permissions contact your systems administrator", then plainly you DO NOT have full admin rights.

    if you are not gettign prompted for a username or password then I suspect your association with the workgroup file is suspect.. you may not be associating/linking with the workgroup file you think you are. Or it may be that you haven't set a password for user admin (the default userid used on workgroup files)
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    How do I associate the database I am trying to link from to the workgroup of the database I am linking from? Or how do I make that database part of the workgroup.

    When I say I have full admin rights I mean I can change any of the settings in the databases I am working with. So if I need to associate one to the other I can. I just dont know how?

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You can open the database with the /wrkgrp switch to specify which MDW file contains the user you need to access the objects in the target database. Then you can log in with that user and you should then have no trouble importing objects.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    Ok - all sounds good but I dont understand how you do that. Can you talk me through.

    Thanks

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Make a shortcut to your database that has a target of something like this:

    MSACCESS.EXE "pathtodatabase" /wrkgrp "pathtoMDWfile"

    You'll have to verify the syntax... I'm sure someone else will correct me.

    I can't give you the specifics step by step right now, sorry, I'm caught for time.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I checked the syntax, it's correct.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  11. #11
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    Quote Originally Posted by StarTrekker
    Make a shortcut to your database that has a target of something like this:

    MSACCESS.EXE "pathtodatabase" /wrkgrp "pathtoMDWfile"

    You'll have to verify the syntax... I'm sure someone else will correct me.

    I can't give you the specifics step by step right now, sorry, I'm caught for time.

    Works a treat, Many thanks

  12. #12
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You're welcome
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  13. #13
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Hey cool, I have over 2000 posts now!

    Do I get a cookie or summink ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  14. #14
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I actually have a packed of white chocolate cookies on my desk right now!
    Send me a SASE and I'll mail it out to you

    Congrats ST
    George
    Home | Blog

  15. #15
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Mmmmmyummmmmmmm ... white chololate..... What's a SASE?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •