Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    5

    Unanswered: Autonumber Issues

    I have a table where the data is constantly being appended and deleted. I want an auto number field that starts at 1 evry time I append data to the table. Any ideas?

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    if you delete then recreate the table, you can get there.
    if you generate your own sequence number, you can also get there.

    access makes a major effort not to do what you want: autonumbers in access are NOT reused.

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •