ASP.NET, SQL Server, WPF, C#, VB.NET

I have reviewed most of the post regarding :split databases and multi-users, 
 
but have not found if the answer I was looking to find. 
 
If the database has auto-numbering on the files; will the split databases 
 
allow one user to enter a record, while the other user enters a record at the 
 
same time, will the database save the second record? I have not used a split 
 
database before now and need to know if the records will be saved. And how 
 
will the autonumbering be assigned to each file? The reason for the question 
 
is our office uses the autonumber to find records, print, and review reports; 
 
and as most know if the autonumber is off, it messes with that process. 
 
Thanks. Tony

"TonyM" <TonyM@discussions.microsoft.com> wrote in message 
 
news:1D86D95C-2E5C-4BB1-90A7-FB9AD3FA95C8@microsoft.com... 
 
If a new record is dirty and another is added to the same table, you will 
 
get a unique autonumbers for both. 
 
Point of order - autonumbers should not be used as meaningful data by users. 
 
They are for internal indexing purposes only. 
 
Keith. 
 
www.keithwilby.com