Re: Clearning Autonumber with ADO??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: sharkz (joao_at_mailme.dk)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 16:16:53 +0100

Hi!!
you can reset the autonumber by doing "compact and repair" in access, for example.

best regards from portugal
sharkz

Relevant Pages

  • Howto findout Ado not connected
    ... I have a few users on an Acces database. ... When i want to compact and repair ... Best regards, ...
    (borland.public.delphi.database.ado)
  • Re: "There isnt enough memory to perform this operation"
    ... Our method of dealing with the problem so far is saving a lot and Compact & ... leaving Design mode. ... Run Compact & Repair on one of the copies. ... large app -- about 72 MB of program with tables linked to another Access ...
    (microsoft.public.access.tablesdbdesign)
  • Re: #Name? error
    ... Have you done a compact and repair, or a decompile followed by compact and ... What happens if you create another database as a test, keep it simple, use ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ...
    (microsoft.public.access.forms)
  • Re: Form Dirty not firing
    ... also forces me to do a backup and compact and repair again. ... MISSING references. ... Database Utilites... ...
    (microsoft.public.access.formscoding)
  • Re: Re-ordering of Tables
    ... clustered index (MSDE) then that is the exception. ... In the case of a compact and repair, the rows added subsequently would not ... clustered index but that has nothing to do with the question at hand. ...
    (microsoft.public.access.tablesdbdesign)