Search:

Type: Posts; User: slgoetze; Keyword(s):

Search: Search took 0.00 seconds.

  1. I had to uninstall and install 11.0.7 from...

    I had to uninstall and install 11.0.7 from scratch.
  2. Thank you.

    Thank you.
  3. Thank you all. Anyone have ddl code to to change...

    Thank you all.
    Anyone have ddl code to to change the primary key to ascending?
    Steve
  4. Thanks John, Please understand that over the...

    Thanks John,
    Please understand that over the last 10 years we have had over 300 sites running this application in various versions leading up to Access 2010. Our choice to use descending is not the...
  5. Thanks ruirib, Now try compacting after applying...

    Thanks ruirib,
    Now try compacting after applying the reseed. It will brak again.
  6. Open table in design view. Select Indexes. ...

    Open table in design view. Select Indexes.
    Please understand that we have had over 300 sites run this application in various versions leading up to Access 2010. Our choice to use descending is not...
  7. Thanks ruirib, That msmvp post was by one of my...

    Thanks ruirib,
    That msmvp post was by one of my contacts at Experts Exchange. Note it was just posted 8/17/2011.
    I cannot find anything on allenbrowne.com
    My question was, "Can anyone else...
  8. We do not mess with autonumber. Access 2010 does...

    We do not mess with autonumber. Access 2010 does during a compact & repair if we have more than 1001 records and PK sort descending.
  9. MS Access 2010 Compact & Repair Breaks AutoNumber

    Steps to duplicate:
    Create new empty mdb or accdb
    Create new Table1
    Fields: ID, autonumber, PK ascending
    F2, text (255)
    Add 1003 records
    Compact & Repair
    Add record 1004 manually, ok...
Results 1 to 9 of 10