Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Brecon, South Wales, UK
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query not replicable (Access 97)

    When I try to make a replica from my Access 97 database I get a message 'couldn't create replica... query object in Tables Container could not be made replicable'. The particular query is quite a complex one, but it executes correctly. If I set the query to be non-replicable in Properties, the create replica action completes successfully. However, once I have set it to non-replicable, if I attempt to redesignate it 'replicable' I get the 'ambiguous outer joins' message. Any suggestions?

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query not replicable (Access 97)

    Can you post the SQL that comprises the query? Somebody may be able to find something...
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Brecon, South Wales, UK
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query not replicable (Access 97)

    Shane: thanks for the offer. However, I have solved the problem. The query linked two tables on the first four fields in each (making up a composite index). For some reason, although all four links specified that the query should show all the records from Table A and only matching records from Table B, the links appeared not to be identical (I think this depends on whether you create the link by dragging from Table A to Table B or vice versa). I deleted and recreated all four links and the problem went away. Curiously, the query in its original form would execute correctly, but would not allow you to view its SQL and would not replicate. Since I couldn't view the faulty SQL, I couldn't tell what the error was. Not sure I understand... <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>

Posting Permissions

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