AUTONUMBER PROBLEM

[amish]

I AM USING ACCESS TABLE HAIVNG MORE THAN 15000 RECORDS AND I HAVE ID FIELD
AS AUTONUMBER
I HAVE A PROBLEM THAT WHEN I ADD NEW ROW IN THE TABLE ACCESS ADDS PREVIOUS
USED VALUE OF ID IN THE AUTONUMBER.I WANT THIS SHOULD BE UNIQUE.

WHAT SHOULD I DO.
IS THERE ANY PERMENANT SOLUTION FOR THIS.

THANKS
AMISH M SHAH

 

[LeAnne]

Hi amish,

Please don't SHOUT!!!!!!!!! It's considered rude.

I AM USING ACCESS TABLE HAIVNG MORE THAN 15000 RECORDS AND I HAVE ID FIELD
AS AUTONUMBER
I HAVE A PROBLEM THAT WHEN I ADD NEW ROW IN THE TABLE ACCESS ADDS PREVIOUS
USED VALUE OF ID IN THE AUTONUMBER.I WANT THIS SHOULD BE UNIQUE.

WHAT SHOULD I DO.
IS THERE ANY PERMENANT SOLUTION FOR THIS.

You haven't given us much to go on, but IF you are using Access 2000,
and IF you are using an Append query to add the new record, see:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209710

If the problem is other, please post back.

Good luck,

LeAnne