You asked in the newsgroup, you get answers in the newsgroup ...

You cannot do this at table level. You must do this via the form that is
used to add records (your ARE using forms for users to add/browse data??).
The easiest way would be to "autoseed" you column with the first value:
1000000. After that, you would use code like this in the BeforeInsert or
AfterInsert event of your form:

Dim lngID As Long

lngID = Nz(DMax("YourIDField")) +1
Me.YourIDField = lngID

To make sure your numbers are unique, add an Index to the underlying table
that includes the field and set Unique = Yes.

If you are asking about customizing the AutoNumbers field ... well, you can
always Format that field to DISPLAY the number any way you like, but the
underlying data will always be stored as a Long datatype. And, there is NO
guarantee that the values will be non-gapped consecutive numbers ... and
using an Autonumber field like that indicates what could be a serious design
flaw in your data.

Surya,

Use the following SQL:

ALTER TABLE tblTable ALTER COLUMN AutoID COUNTER (1000000,1);

The first number is the Starting value, the second is the increment.

That said, Doug Steele gives good advice, and you'll likely save
yourself trouble if you heed it.

-Ken

My email address is wrongly spelt in my earlier request.  
The correct email address is: DHURJSU@KELLYSERVICES.COM
Thanks,
Surya