This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Reset the Auto Number Column Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Reset the Auto Number Column" Watch "Reset the Auto Number Column" New topic

Reset the Auto Number Column

Sri Gnana
Ranch Hand

Joined: Apr 29, 2004
Posts: 166
Hi friends,
I want to reset the Auto Number Coloumn , I'm using MSAccess,can any one help me?

Thanks & Regards
Sri Gnana
Everythings Programmed!...
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

As I remember this is a feature of the access application itself, not SQL so you can't do it through JDBC. But then this is a sort of DBA task, so you shouldn't do it through JDBC anyway.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Sri Gnana
Ranch Hand

Joined: Apr 29, 2004
Posts: 166
Hi Paul
Thanks, i did it.Just i delete the auto number column and again create a new column.
I agree. Here's the link:
subject: Reset the Auto Number Column
It's not a secret anymore!