Re: Renumbering MS db ID?
From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 08/16/04
- Next message: MicrosoftRocks: "Re: ADODB.Command"
- Previous message: William Ryan eMVP: "Re: Renumbering MS db ID?"
- In reply to: Mr. B: "Renumbering MS db ID?"
- Next in thread: Mr. B: "Re: Renumbering MS db ID?"
- Reply: Mr. B: "Re: Renumbering MS db ID?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 16 Aug 2004 08:13:56 -0500
On Sun, 15 Aug 2004 16:31:02 GMT, Mr. B <User@NoWhere.com> wrote:
¤ I have a small MS db which I update daily with new info. I've noticed that
¤ the ID numbers are increasing sequentially. How can I reset them back to 1
¤ when I purge my data prior to adding in the new stuff?
¤
¤ Here is how I'm currently deleting the info from my db (TSUpdate):
¤
¤
¤ Private Sub ClearMyData()
¤ ' Open Connection and Clear Data
¤ OleDbConnection1.Open()
¤ Dim MyCommand As New OleDbCommand("DELETE FROM TSUpdate",
¤ OleDbConnection1)
¤ MyCommand.ExecuteNonQuery()
¤ OleDbConnection1.Close()
¤ MyCommand.Dispose()
¤ End Sub
¤
¤
¤ Thanks in advance!
See the following MS KB article:
How to reset an AutoNumber field value in Access
http://support.microsoft.com/default.aspx?scid=kb;en-us;812718
Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)
- Next message: MicrosoftRocks: "Re: ADODB.Command"
- Previous message: William Ryan eMVP: "Re: Renumbering MS db ID?"
- In reply to: Mr. B: "Renumbering MS db ID?"
- Next in thread: Mr. B: "Re: Renumbering MS db ID?"
- Reply: Mr. B: "Re: Renumbering MS db ID?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
