Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Location
    Brighton, UK
    Posts
    2

    Unanswered: Compact and Autonumber problem

    I have a table with an Autonumber field. I can add rows to the table fine, but after the DB is compacted the next Autonumber value Access 2002 tries to use already exists and the insert fails. The only way to fix it is to reset the next autonumber value, but I don't want to have to do this everytime I compact the DB. Anyone else had a similar problem or even know of a solution??

    TIA Jenx

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    This is a known bug in MS Access. In order to fix it you have to install update for the Jet engine. Details can be found in the link below:

    http://support.microsoft.com/directo...;en-us;Q239114

    Related link:
    http://support.microsoft.com/directo...EN-US;Q257408&

    Igor

  3. #3
    Join Date
    Jul 2002
    Location
    Brighton, UK
    Posts
    2
    thanks alot - I can't believe that for all of my searching I never found that myself

Posting Permissions

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