Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked Table Manager (v2000)

    I have SQL tables linked in Access and they work fine.
    However, if I run the linked table manager on the SQL
    tables, I am informed that the links refreshed. When I
    open the tables, they are read-only. If I delete the
    tables and re-link them, they work fine again.
    Any ideas why this occurs?
    Thanks!

  2. #2
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Table Manager (v2000)

    I'm not sure that I followed your situation 100%, but perhaps the SQL SERVER permissions on your tables are set to read-only - ie. only SELECT, not UPDATE, INSERT, or DELETE?

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Table Manager (v2000)

    Thanks Taibe,

    I found the following info to explain why:
    When you first attach the
    tables and if you specify the unique identifier for the
    table, this information is stored in Access. If you refresh
    the links, the information you specified for the unique
    identifier can be lost. So you either need to have a primary
    key on the tables or refresh the links programmatically and
    specify the unique index.

  4. #4
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Table Manager (v2000)

    I know this is a very late response but...
    Thanks for the info! I think it may be relevant to a problem I'm having now - see <post#=390571>post 390571</post#>

  5. #5
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Table Manager (v2000)

    Thanks TJ!

Posting Permissions

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