Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Wales
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Loss of relationships (Access 2000)

    I have completed 2 dbases and had them running now for some two months or so, untill recently no problems , except the occasional c&r . Suddenly i'm experiencing all sorts of problems from dissappearing relationships ,to unable to save the query that I've just created. I thought that it was a corrupt Access instalation and subsequently had the machine rebuilt- - guess what nothing changed. Has anyone experienced this before and if so HOW DID YOU FIX IT!! - please share the secret before I ware away to nothing. My team and I ( me and the large bottle of 'shrinking' scotch )are at a complete loss as to what is going on. Most of the db's are a mixture of code ( VBA and SQL ) and a mixture of DAO and ADO. If any of this is a little vague I'm quiet willing to expound the problems in more graphic detail , if you can bear the pain!! I would be grateful of any possible solutions, if there are any. <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Loss of relationships (Access 2000)

    I don't know what the problem is but you can try this:
    Create a new blank database.
    Import all the objects from the "broken" database.
    Rebuild the relations and see if the problems are solved.
    Francois

Posting Permissions

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