aspose file tools*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Reset the Auto Number Column" Watch "Reset the Auto Number Column" New topic
Author

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
Bartender

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: http://aspose.com/file-tools
 
subject: Reset the Auto Number Column