AutoNumering Problem in Microsoft Access

[Ali Imran]

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

[Arthur Wood]

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
>

[Sue Harsevoort]

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
> >
>