AutoInc in mdb

From: "limelect" <limelect@xxxxxxxxxxxx>
Date: Wed, 19 Mar 2008 10:58:47 +0200

I would like to know the next number in a mdb autoincrment field.
However just taking the last number+1 is not correct
since if you delete a record the next one will be +2
and so on
P.S i tried 'select @@IDENTITY as [ID]' not wirking

.

Follow-Ups:
- Re: AutoInc in mdb
  - From: Paul Scott

Prev by Date: Re: ADO Connection
Next by Date: Re: AutoInc in mdb
Previous by thread: ADO Connection
Next by thread: Re: AutoInc in mdb
Index(es):
- Date
- Thread