Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    When i link tables as above in a query i cannot change the data in the query.

    If i have the tables in 2 different backend in access it works fine.

    Do i need to make sure my sql server table's join field is unique?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    [quote name='patt' post='780599' date='19-Jun-2009 16:52']When i link tables as above in a query i cannot change the data in the query.

    If i have the tables in 2 different backend in access it works fine.

    Do i need to make sure my sql server table's join field is unique?[/quote]
    No probs, i found the Access table had a non unique field that was used as the join field

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Does this mean that Post 780593 has been solved?

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    [quote name='HansV' post='780608' date='19-Jun-2009 19:18']Does this mean that Post 780593 has been solved? [/quote]
    No that's another problem

Posting Permissions

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