AutoNumering Problem in Microsoft Access


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: AutoNumering Problem in Microsoft Access

  1. #1
    Ali Imran Guest

    AutoNumering Problem in Microsoft Access


    Hi Folks,

    Can I truncate the Microsoft Access Table as we can do in Microsoft SQL Server?

    Pls reply on my Email for answer.

    Thanks!
    Ali Imran
    Riyadh, Saudi Arabia


  2. #2
    Arthur Wood Guest

    Re: AutoNumering Problem in Microsoft Access


    Ali,
    What do you mean by "truncate"?

    Arthur Wood


    "Ali Imran" <aimran@bigfoot.com> wrote:
    >
    >Hi Folks,
    >
    >Can I truncate the Microsoft Access Table as we can do in Microsoft SQL

    Server?
    >
    >Pls reply on my Email for answer.
    >
    >Thanks!
    >Ali Imran
    >Riyadh, Saudi Arabia
    >



  3. #3
    Sue Harsevoort Guest

    Re: AutoNumering Problem in Microsoft Access

    My guess is he is talking about Truncate Table. It is basically the same as
    Delete From tblTable except it does not log the individual row deletes
    because it removes the data by deallocating the data pages instead of
    deleting one row at a time So it is faster and uses fewer system and
    transaction log resources.

    I don't think there is anything equivilant to it in Access.

    Sue

    "Arthur Wood" <wooda@saic-trsc.com> wrote in message
    news:3bab2a4b$1@news.devx.com...
    >
    > Ali,
    > What do you mean by "truncate"?
    >
    > Arthur Wood
    >
    >
    > "Ali Imran" <aimran@bigfoot.com> wrote:
    > >
    > >Hi Folks,
    > >
    > >Can I truncate the Microsoft Access Table as we can do in Microsoft SQL

    > Server?
    > >
    > >Pls reply on my Email for answer.
    > >
    > >Thanks!
    > >Ali Imran
    > >Riyadh, Saudi Arabia
    > >

    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center