Hi All,
   I am working on a small project which have a ADO & ACCESS as database. I m tring to implement a multiuser entry screen. I m getting a problem that when 2 users saves entry at same time the entry no. gets same to both users.
  Pls help how to avoid this problem

swapnil       

Hi,
This is because the Microsoft "Jet" Database Engine can take up to 5 seconds to clear its cache and write to disk. This is by design (its called "Lazy Write") so that performance is improved, but it can cause problems where you have a lot of users. remember that the Access database was not designed for high multi-user input - SQL-Server is the datbase for this. But don't despare, there is a way to take control of the "counter", or Auto-number, field. Take a look at this article that gives the code for the workaround :-
http://support.microsoft.com/kb/240317/en-us


____________________________
multi-tasking - the ability to hang more than one app. at the same time.