Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    277

    Unanswered: after resetting the number no info on reports

    what da heck is goin on... i reset the reference # and now none of the queries work

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    How so?

    If you reset ONE table that had dependencies, then you just borked your entire db.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Dec 2004
    Posts
    277
    sweet... i dicked it... so i guess that means i gotta start over huh?

    i mean from my last backup

    and i'm sorry for all the questions but i just wanna make sure this things works the best it can...

    why would only one form be extremely slow compared to the rest of the database? any ideas throw em at me cuz i've tried compact/repair and debugging...
    Last edited by DackJaniels; 01-05-05 at 12:37.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Did you break referential integrity? If so, then yes, you do.

    Basically if you have a table with a foriegn key of 500 pointing at another table, and suddenly you reset all the numbers in that other table, the query isn't going to function.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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