Take a look at this...
http://msdn.microsoft.com/library/de...adonetbest.asp
....and do a search for '-1'
The basic idea is that autoincrement fields local to the machine
go -1, -2, -3 but that they get updated with the correct, central
database
generated value, when you push the new rows back to the server.
Also please see the ADO.NET newsgroup. You will find it helpful.
"Çinko" <cozgel(erase)@hotmail.com> wrote in message
news:uo**************@TK2MSFTNGP14.phx.gbl:
Hi,
i know the problem i will tell you belongs to database newsgroup but
maybe
there is a way for VB to do that.
I use integer id for customers. Access database give autonumber as id
for
customers. When i erase a customer, database doesn't use it's id number
for
another customer again. Is there any way for database or VB to solve
that
problem??
Thank you..