How to reset the AutoIncrement column in an Access database  
Author Message
Ayooya





PostPosted: Visual C# General, How to reset the AutoIncrement column in an Access database Top

Hi,

I have made an Access database , named IntermediateResults database, and connect it to my C# application.

I have use the TableAdapter to deal with the database tables from C# application.

This database tables have an AutoNumber columns, and when I add raws they are auto increment.

If I clear the table , using a ClearQuery, and try to fill it again with new records , that columns does not initialized to start from 0 again, it continue the increment.

I need to reset its value to start from 0, how can I do that

Thanks in advance,

Aya.



Visual C#4  
 
 
ahmedilyas





PostPosted: Visual C# General, How to reset the AutoIncrement column in an Access database Top

take a look at this:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=847484&SiteID=1