Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking data to secured database (2000)

    I'm trying to link data from a secured Access database (of which I am the administrator) to a spreadsheet and am just getting the usual "you do not have the neccessary permissions...." I've tried removing any security from the table I want to link to but nothing seems to be working. I have also tried joining the Access workgroup before attempting the link. Any help would be deeply appreciated.

    Thanks,
    Eric

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Linking data to secured database (2000)

    Does this <post#=135460>post 135460</post#> answer your question?

    Steve

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking data to secured database (2000)

    Afraid not. I'm linking the data in the database table to an Excel spreadsheet and using Excel to view it. Microsoft Query is evidently being prevented from establishing the link by the security set up on the database

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Linking data to secured database (2000)

    I'm afraid I don't fully understand what you are doing, but the approach seems to me to be problematic. Am I correct in assuming that you are actually linking to an Excel workbook from Access, and you can then view that data as a table? Or have you used MS Query to link to an Access table (stored in your MDB file)? If it's the former, then you can't view the data simultaneously from Access and Excel because Excel is not multi-user. If it's the latter, you will probably need to create an ODBC data source that specifies the security workgroup, userID and password in order to get at the secured Access database table. Let us know which way you are trying to work and we'll do our best to help.
    Wendell

  5. #5
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking data to secured database (2000)

    It's the latter.

    Thanks for your help.

    Eric

    Wendell - my middle name.

  6. #6
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking data to secured database (2000)

    Thanks for pointing me in the right direction. I believe I've worked it out.

    Eric

Posting Permissions

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