Change the starting value of an AutoNumber field

  • Thread starter Thread starter Edgar Minchuk
  • Start date Start date
E

Edgar Minchuk

Dear Sir or Madam

I have tried to start from my value in the AutoNumber and
did it according to help of Acces .

However every time I got the message as "Duplicate output
destination 'MyName'."

Could you help me , Please ?

Thank you in advance.

Edgar
 
Sounds like you've chosen the wrong query type--you want an update query,
not a create query.

Beyond that, it needs to be said that if you care what the value is, you
shouldn't be using an Autonumber in the first place. Autonumbers are
guaranteed to be unique, but they're not guaranteed to be sequential (or
even sensible <g>).

HTH, anyway.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Back
Top