AUTONUMBER PROBLEM

  • Thread starter Thread starter amish
  • Start date Start date
A

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
 
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.
Click to expand...

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