Results 1 to 2 of 2

Thread: Auto Number Field in MS Access

  1. Jan 10th, 2000, 09:22 PM #1
    SteFlitII
    SteFlitII is offline

    Thread Starter
    New Member
    Join Date
    Jan 2000
    Location
    Blackpool
    Posts
    14

    Post

    Can I reset the value of an auto-number field in an MS Access Database through VB.
    My problem is that I create new fields and also delete fields therefore the autonumber field is getting very large. Any help welcome
    Reply With Quote Reply With Quote
  2. Jan 10th, 2000, 10:14 PM #2
    Mark Sreeves
    Mark Sreeves is offline
    Frenzied Member Mark Sreeves's Avatar
    Join Date
    Nov 1999
    Location
    UK
    Posts
    1,845

    Post

    YES!

    I had a problem some time ago when the auto number kept resetting itself

    Delete any unwanted data and compress the database this will re-set it!

    ------------------
    Mark Sreeves
    Analyst Programmer

    [email protected]
    A BMW Group Company
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width